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

[sillaak1]

• SYS-E-HTTPFAIL, Cannot connect to SQL Server.
• SYS,GENERAL_EXCEPTION,Cannot connect to SQL Server,RetCode: SQL_ERROR SqlState: 08001 NativeError: 53 Message: [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53].

[Maria_Halley]

@sillaak1

What Qlik product are you using? 

[Colin-Albert · Accepted solution]

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 · Accepted solution]

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:

• https://techyaz.com/sql-server/troubleshooting/fix-error-53-not-open-connection-sql-server/
• https://stackoverflow.com/questions/9945409/how-do-i-fix-the-error-named-pipes-provider-error-40-cou...

Best Regards