Skip to main content

Qlik Compose for Data Warehouses

Discussion board for collaboration on Qlik Compose for Data Warehouses.

Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor
Partner - Contributor

Unable to Connect to SQL Server


I have a sandbox in AWS running Replicate 6.6, Compose 6.6, SQL Server 2017 and MySQL.

Replicate can connect to a SQL Server source with no problem.

Still, on Compose, when I try to add SQL Server as the EDW, I get:

"SYS,GENERAL_EXCEPTION,A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections."

The connection is exaclty the same as I'm using for Replicate: a simple 'localhost' and port 1433.

Could anyone help figure out what may be causing this error?


Labels (1)
2 Replies

Hi Alvaro,


Did you enable the TCP/IP protocol for SQL Server?  I suspect that is the issue you are experiencing.  In your Windows instance where SQL server is installed, go to SQL Server Configuration Manager, and select "SQL Server Network Configuration".  There is a Protocol option for your SQL server.  Three protocol names can be found:  Shared Memory, Named Pipes, and TCP/IP.   If the TCP/IP is disabled, please, enable it, and restart the SQL server service.  Then, test your connection in Compose.  Ben