Question

Does QIE support "Named Instance" database connections?

Answer 1

Yes, QIE supports database connections using a Named Instance.

To specify a database connection using a named instance you include both the server name and the named instance in the hostname field separated by a back slash.

e.g. localhost\namedInstance

References:

https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017

https://confluence.atlassian.com/stashkb/connecting-to-named-instances-in-sql-server-from-stash-443548795.html

Comments

Depending on your Microsoft SQL Server configuration, you may need to click the "Manually set the connection URL" and remove the port.  So instead of:

jdbc:sqlserver://hostname\instancename:1433;databaseName=TestDB

change to:

jdbc:sqlserver://hostname\instancename;databaseName=TestDB

Answer 2

Also see this related question that shows how to discover or change the port.  Typically mulitple named instances exist on a box, each with a different port.

https://www.qvera.com/kb/index.php/125/how-can-i-connect-to-ms-sql-server-express-database-using-qie?show=125#q125