Qlik Sense Enterprise: MS SQL Connector - configure DB instance

[fe-c]

Hi,

is it possible to configure the DB/SQL instance in the "Create new connection (Microsoft SQL Server)" dialog?

I'm not able to establish a connetion to "servername\instance02".

I tried directly the "Server" input field and also the "Advanced" options with name "instace" and value "instance02", but it does not work.

[RenuLalwani · Accepted solution]

Hello,

Qlik MSSQL connector connects to the default instance "MSSQLSERVER" on default port 1433

To connect to other named instances (apart from default), either assign a static port other than 1433 to your named instance, or use dynamic port range value "0" in Port field.

Make sure the SQL browser service is running. (you might need to check this with your IT or DBA admin if you are not the owner of the SQL Server or DB)

Hope this helps!

[fe-c]

Using the port "0" solved this problem for me. 

Thanks for guidance!