error 08001: trying to connect SQL Server Management Studio with Qlik Sense

ioannaiogr — Wed, 08 Mar 2023 15:55:14 GMT

Hi all,

so, it's my first time trying to connect SQL Server Management Studio with Qlik Sense. In fact it's my first time setting up a database, so bear with me, I don't have the vocabulary for the terms.

Well, the access to the SQL DB server was set to Windows Authorization so there is that one user (let's say user1) and I also have a user with credentials (username/psw) for SQL Server Authorization (let's say user2). These both have every permission granted and their role is set to public.

Now, trying to connect Studio with Qlik Sense, I firstly chose "Microsoft SQL Server" in the available connectors. The connection fails (servername is ok, username is ok, psw is ok, db name is the one i want to load so i guess it's ok?) . Then I looked it up and tried with OLE DB, again connection fails. With ODBC connection alone i have no clue what to do.

What am i missing?

Could really use your help to go forward with this.

Really appreciated!

Thank you in advance!

Re: error 08001: trying to connect SQL Server Management Studio with Qlik Sense

ioannagr — Thu, 09 Mar 2023 16:23:18 GMT

Some help, please?

Re: error 08001: trying to connect SQL Server Management Studio with Qlik Sense

RenuLalwani — Fri, 10 Mar 2023 07:13:27 GMT

So you able to connect to the SQL server through SSMS and not through Qlik Sense correct?

Could you please share screenshots? (of successful connection through SSMS) and (of error in Qlik Sense)

Thanks!

topic Re: error 08001: trying to connect SQL Server Management Studio with Qlik Sense in Connectivity & Data Prep

error 08001: trying to connect SQL Server Management Studio with Qlik Sense

Re: error 08001: trying to connect SQL Server Management Studio with Qlik Sense

Re: error 08001: trying to connect SQL Server Management Studio with Qlik Sense