connecting to a MS SQL with windows auth

[johanfo2]

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?

[achettipalli]

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.

[jobsonkjoseph]

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.

[eadka]

Thanks this worked perfectly