Error [08001][Qlik][SqlServer] Failed to locate Server/Instance Specified

[Sonja_Bauernfeind]

Connecting to a Microsoft SQL Server fails with

An Error occurred Error [08001][Qlik][SqlServer] Failed to locate Server/Instance Specified. 

Verify connection settings and driver used. 

Example: Use MS SQL ODBC driver. See How To Connect MS SQL Server Using Native ODBC Driver for an example on how to correctly set up the connection. 

Verify that Port is set to 0 when creating a connection.

When connecting to a Named Instance, make sure to set the Port to 0 (zero) when creating the connection. This will utilize SQL Server Browser service  to redirect to the Named Instance.

[tom_tierney]

All,

I hit this problem earlier this afternoon in a test environment. It took an hour of so to resolve. Firstly in Windows > Control Panel > Admin Tools > Services ensure that both SQL Server Agent & SQL Server Browser are running. Set both to Automatic start etc. Next Start the SQL Configuration Manager for whichever version of SQL you are running.  Ensure that the TCPIP protocol is enabled for all configurations. e.g. SQL Native Client XX 32 bit config, SQL Server Network Config, SQL Native Client XX config.

Reboot

Try Again

Tom