topic Re: connecting to a MS SQL with windows auth in Connectivity & Data Prep

connecting to a MS SQL with windows auth

johanfo2 — Fri, 02 Nov 2018 14:19:38 GMT

I have used Qlikview for some time, and thought I should try QlikSense (Desktop).

I hit a brick wall almost immediately with Qlik Sense regarding connecting to a MS SQL Server database. From my PC, I have windows authentication access to a MS SQL Server database, however, I seem to get no option at all from QlikSense to chose windows authentication. The form only shows classic "username/password"?

I tried to search the docs, but without luck. What is wrong?

Re: connecting to a MS SQL with windows auth

achettipalli — Fri, 02 Nov 2018 14:38:22 GMT

Hi Johan,

You could try other way around like the one in this discussion : Using a Windows Service Account in a DB Connection

Or through ODBC.

Re: connecting to a MS SQL with windows auth

jobsonkjoseph — Fri, 02 Nov 2018 14:57:05 GMT

Hi Johan,

How are you trying to connect to MSSQL in qlik sense.

There are two ways to connect using "Create New Connection" option;

1. Microsoft SQL Server data source

2. OLEDB

If i'm not wrong you'll be able to give the credentials you want to using OLEDB if selected.

Pls do correct me if i'm wrong.

Re: connecting to a MS SQL with windows auth

eadka — Mon, 29 Jul 2019 03:54:24 GMT

Thanks this worked perfectly