Microsoft SQL Server Data Connector Is Not Working
I am currently having an error whenever I use the built in connector for Microsoft SQL Server. This is the error that I am getting: Client unable to establish connection. Error 08001 [qlik] [sqlserver] problem establishing connection to the server.
I tried the following things:
1. Created an ODBC connection using "SQL Server". Result: State: 08001, Error: 18 SSL Error.
2. Installed Microsoft SQL Server to test the connection. I can access the database using the same credentials in Microsoft SQL Server Management Studio. Result: Working.
3. Created an ODBC connection using "SQL Server Native Client 11.0" that comes with the installation of Mircosoft SQL Server. Result: Working.
4. Created and OLE DB connection using "SQL Server Native Client 11.0" that comes with the installation of Mircosoft SQL Server. Result: Working.
It seems that using the SQL Server Native Client will allow me to connect to the database. But we only installed the MS SQL Server for testing purposes and would like to remove it afterwards. Is there any fix to allow me to use the built-in data connector for Microsoft SQL Server? Just to add, we are currently using Multi-Node environment.
Thanks for the reply. I am getting the SSL Error when I am setting up the ODBC connection through Windows. The Encrypt tick box is unchecked when I am attempting to create a Microsoft SQL Server Data Connection.