Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sillaak1
Contributor
Contributor

Always on Error ( Could not open a connection to SQL Server [53].) when connecting to Database

Labels (2)
2 Solutions

Accepted Solutions
Colin-Albert

This is an error is due to Qlik not being able to connect to the SQL server.

Has this ever worked or do other Qlik apps connect to this server OK? 
Is the SQL server name & instance correct?
Are the ports used by SQL blocked by your firewall, usually port 1443?
Is named pipes configured on your SQL Server?

View solution in original post

Chip_Matejowsky
Support
Support

Hi @sillaak1 
The error [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53]  is returned in Qlik logs as that is what the product is receiving from the source. So this is not a Qlik error, per se.  As Collin stated, Qlik cannot connect to the SQL server.

I did a Google search on the error and the below URLs were returned which may assist you:

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

3 Replies
Maria_Halley
Support
Support

@sillaak1

 

What Qlik product are you using? 

Colin-Albert

This is an error is due to Qlik not being able to connect to the SQL server.

Has this ever worked or do other Qlik apps connect to this server OK? 
Is the SQL server name & instance correct?
Are the ports used by SQL blocked by your firewall, usually port 1443?
Is named pipes configured on your SQL Server?

Chip_Matejowsky
Support
Support

Hi @sillaak1 
The error [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53]  is returned in Qlik logs as that is what the product is receiving from the source. So this is not a Qlik error, per se.  As Collin stated, Qlik cannot connect to the SQL server.

I did a Google search on the error and the below URLs were returned which may assist you:

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!