Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-01-25 10:07 AM

New User trying to connect to SQL getting this error

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.

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

12.pngScreenshot_6.png

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. Screenshot_7.png

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.

Thank You.

971 Views
0 Likes
0 Replies