Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
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.
