topic Qlik Sense Enterprise: MS SQL Connector - configure DB instance in Connectivity & Data Prep

Qlik Sense Enterprise: MS SQL Connector - configure DB instance

fe-c — Tue, 07 Jan 2025 10:13:54 GMT

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.

Re: Qlik Sense Enterprise: MS SQL Connector - configure DB instance

RenuLalwani — Mon, 13 Jan 2025 05:27:47 GMT

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!

Re: Qlik Sense Enterprise: MS SQL Connector - configure DB instance

fe-c — Mon, 13 Jan 2025 06:43:59 GMT

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

Thanks for guidance!