Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
mhamlett101
Contributor
Contributor

can qlik connect to ms sql express db? I cant get the connection to work

can qlik connect to ms sql express db? I cant get the connection to work

Labels (1)
3 Replies
Thiago_Justen_

Please take a look at https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/LoadData/connect-data-... 

 

 

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
ChristofSchwarz
Partner - Creator II
Partner - Creator II

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:

ChristofSchwarz_0-1661432491218.png

then set the port for TCP/IP connections

ChristofSchwarz_1-1661432508318.png

 

 

NadiaB
Support
Support

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 .

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm