Trying to create a JDBC connection to SQL Server 2016. We use Named Pipes on a few of our hosts. ie. localhost\SQLDEV02
I cannot see anywhere to configure the sql instance name in the JDBC connection details page???
Have tried adding it to the serverName field after the host with no luck either.
The connection works fine on SQL servers that dont have named pipes. Even used it to connect to Azure SQL with no issues.
Googled the death out of this. Found plenty of examples of Webmethods JDBC connections to SQL server that dont use named pipes. Doesnt anyone use named pipes these days?