Connect to a non-default instance of MS SQL server

[Dan]

How would I connect to a non-default instance of MS SQL server? I don’t see any fields in the GUI or database.conf.spec for that. With MS tools or ODBC settings, I’d just specify SERVER\INSTANCE but that doesn’t seem to work with DBX.

[the0duke0]

In my case when using the DBConnect 2.3.1 and MS Generic driver, I had to edit the JDBC URL format to omit the :<port> tag, leaving it as:

jdbc:sqlserver://<host>;databaseName=<database>;selectMethod=cursor

You can do this within the connection screen. Then you can specify the Server field as <servername>\<instancename>, as you normally would for named instances.

[igritsak]

Removing the and changing the Host filed to use the typical MSSQL convention is what finally worked for me. Thank you!

[ktvrznik]

Confirm that. If you remove port from JDBC URL. Its working

[Dan · Accepted solution]

At the moment, you can specify the named instance in the database field as:

<instance>/<database>

eg.
someinstance/northwind

or in database.conf:

database = someinstance/northwind

Alternatively you can specify the TCP port the named instance is listening on.

[Thanks to Siegfried for the answer]

[gfuente]

Thanks for the answer. This should be in the documentation