topic New User trying to connect to SQL getting this error in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/New-User-trying-to-connect-to-SQL-getting-this-error/m-p/7343#M91 <HTML><HEAD></HEAD><BODY><P>Hello, I am trying to support a client of ours who is new to using Qlik. I have some very basic understanding of how it works but were having an issue with getting an SQL Server connection authenticate properly. </P><P></P><P>They are using a watchguard firewall and I have created a SNAT rule using the external IP to allow any traffic coming in and out on ports 1433 to be forwarded directly to the SQL server's IP. I verified the TCPIP port SQL is using is 1433 as well. We filled out the Connector properly and hit test</P><P></P><P><IMG alt="12.png" class="jive-image image-1" height="354" src="https://community.qlik.com/legacyfs/online/191403_12.png" style="height: 353.585px; width: 346px;" width="346" /><IMG alt="Screenshot_6.png" class="jive-image image-2" height="195" src="https://community.qlik.com/legacyfs/online/191404_Screenshot_6.png" style="height: 195.24px; width: 437px;" width="437" /></P><P></P><P>I verified the username and password and even used the SYSADMIN account I have and it fails. However, on this machine can open ODBC Data Sources and create an ODBC SQL connector and test it successfully. <IMG alt="Screenshot_7.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/191405_Screenshot_7.png" style="height: 525px; width: 620px;" /></P><P></P><P>I'm not sure what the issue is, but it seems it's directly tied to the QLIK website ODBC connection. Any help would be appreciated. </P><P></P><P>Thank You.</P></BODY></HTML> Thu, 25 Jan 2018 15:07:57 GMT Anonymous 2018-01-25T15:07:57Z New User trying to connect to SQL getting this error https://community.qlik.com/t5/Connectivity-Data-Prep/New-User-trying-to-connect-to-SQL-getting-this-error/m-p/7343#M91 <HTML><HEAD></HEAD><BODY><P>Hello, I am trying to support a client of ours who is new to using Qlik. I have some very basic understanding of how it works but were having an issue with getting an SQL Server connection authenticate properly. </P><P></P><P>They are using a watchguard firewall and I have created a SNAT rule using the external IP to allow any traffic coming in and out on ports 1433 to be forwarded directly to the SQL server's IP. I verified the TCPIP port SQL is using is 1433 as well. We filled out the Connector properly and hit test</P><P></P><P><IMG alt="12.png" class="jive-image image-1" height="354" src="https://community.qlik.com/legacyfs/online/191403_12.png" style="height: 353.585px; width: 346px;" width="346" /><IMG alt="Screenshot_6.png" class="jive-image image-2" height="195" src="https://community.qlik.com/legacyfs/online/191404_Screenshot_6.png" style="height: 195.24px; width: 437px;" width="437" /></P><P></P><P>I verified the username and password and even used the SYSADMIN account I have and it fails. However, on this machine can open ODBC Data Sources and create an ODBC SQL connector and test it successfully. <IMG alt="Screenshot_7.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/191405_Screenshot_7.png" style="height: 525px; width: 620px;" /></P><P></P><P>I'm not sure what the issue is, but it seems it's directly tied to the QLIK website ODBC connection. Any help would be appreciated. </P><P></P><P>Thank You.</P></BODY></HTML> Thu, 25 Jan 2018 15:07:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/New-User-trying-to-connect-to-SQL-getting-this-error/m-p/7343#M91 Anonymous 2018-01-25T15:07:57Z