Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can qlik connect to ms sql express db? I cant get the connection to work
Please take a look at https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/LoadData/connect-data-...
Trapped into the same with the Qlik Connector Package. The reason that it cannot connect to SQLEXPRESS is not the package but the fact, that MS SQL Server Express has TCP/IP Connections turned off by default. Do this from the SQL Server Configuration Manager:
then set the port for TCP/IP connections
Hi @mhamlett101
Along with the suggestions above, the server value should be the same that you see in the SQL Managament Studio, if see something like SQLEXPRESS\<Instance name> it needs to be provided the same way.
It would help if you could indicate what are the errors that you see to clarify where the issue relies.
Thank you .