Qlik Sense SQL Connector is failing with error "Unable to find the instance name or server name".

[Daniele_Purrone]

Qlik Sense SQL Connector is failing with error "Unable to find the instance name or server name"

Environment

• Qlik Sense Enterprise on Windows, any 

Resolution

Qlik applications can communicate with SQL using a TCP/IP connection. To verify that the SQL Server that will host the Qlik database has TCP/IP enabled.
NOTE: Make note of the port that SQL is using. Example port 1433 or 1434 which is default sql port and you may use custom ports as well.

Please follow below instructions:

1. To configure TCP/IP protocol for the SQL Server:
   1. Start SQL Server Configuration Manager.
   2. In the console pane, expand SQL Server Network Configuration, and select the Protocols item for your SQL instance. For example, if you are using the default MSSQLSERVER instance, select Protocols for MSSQLSERVER.
   3. In the details pane, locate the entry for TCP/IP and check the Status column. If it's set to Enabled, go to step 2 to determine the port being used.
   4. If TCP/IP is set to Disabled, double-click TCP/IP to open the TCP/IP Properties window.
   5. Select the Protocol tab, click Enabled, and select Yes.
   6. Click Apply and then OK to close the Warning dialog.
   7. TCP/IP is enabled. You can now restart the service to make sure that your changes take effect.
   8. In the console pane, click SQL Server Services.
   9. In the details pane, right-click the SQL Server service and click Restart.
      
      
2. To determine the port being used by SQL:
   1. If needed, start SQL Server Configuration Manager, expand SQL Server Network Configuration, and select the Protocols item for your SQL instance.
   2. Double-click TCP/IP to open the TCP/IP Properties window.
   3. Select the IP Addresses tab.
   4. Make sure Enabled is set to Yes for each active IP address.
   5. Under IPAII, make note of the value for TCP Dynamic Ports.
   6. If there is a value specified, for example 57482, your SQL Server is using dynamic ports. Make a note of the value because this information might be needed later in the installation.
      
      NOTE: If you are using dynamic ports, the SQL Browser service must be running on the SQL Server. If the value for TCP Dynamic Ports is blank, then your SQL Server is using a static port and the value for this port will be shown in the TCP Port field.
      
      
3. When using dynamic ports, make a note of the SQL instance name that will host the Qlik database. When using the default instance for SQL, the instance name is MSSQLSERVER.