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!
