topic MS SQL Server ODBC Connection with Multiple Users in Connectivity & Data Prep

MS SQL Server ODBC Connection with Multiple Users

jelwood — Fri, 19 Mar 2021 17:55:10 GMT

Hello All,

I have multiple admin users at my organization that need to be able to utilize the ODBC connection to load data from our MS SQL Server. One of the Admins in Qlik has established the ODBC and is able to load data into apps; however, whenever I attempt to connect to the ODBC using the same connection, I get an error message. Is this a permissions issue within Qlik? Are multiple Admins able to utilize the same ODBC connection? Any advice would be helpful, as our team is very new to Qlik. We are using the Qlik Sense SaaS edition.

Thank you!

Re: MS SQL Server ODBC Connection with Multiple Users

Nicole-Smith — Fri, 19 Mar 2021 19:23:00 GMT

In the Security Rules, you will need to make sure the other users are given access to at least read that connection. If that still doesn't work, I think you'll need to post the error message in order to help further.

Re: MS SQL Server ODBC Connection with Multiple Users

jelwood — Fri, 19 Mar 2021 19:43:35 GMT

Would the "Security Rules" be associated with the ODBC setup or something that is altered within Qlik?

Re: MS SQL Server ODBC Connection with Multiple Users

Nicole-Smith — Fri, 19 Mar 2021 19:47:49 GMT

Security Rules is a section in the QMC where access is granted for everything in the environment. You'll need to work with someone who has access to that section to see how access to the Data Connections is applied.

Re: MS SQL Server ODBC Connection with Multiple Users

jelwood — Fri, 19 Mar 2021 19:48:41 GMT

Perfect! Thank you!