Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
zbeauchemin
Partner
Partner

Do I need SQL Server credentials for SQL Server or OLEDB Connection

Hello. I am attempting to connect to SQL server databases where I have read-only access via windows authentication. Can you connect to SQL Server databases via Windows Authentication or do I need to use a SQL Account?

3 Replies
isingh30
Specialist
Specialist

You can do both the ways. It's depends on your use.Whats's the challenge? Via windows you have to setup usename & password.

ajaysingh285
Contributor III
Contributor III

Hi Zach,

Please find my below comments:-

It can be either both the ways....

1. Connect to SQL Server databases via Windows Authentication:-Yes you can connect directly via Windows Authentication

2. do I need to use a SQL Account:-Your admin team member will provide you the user name and password for SQL.


Regards,

Ajay

chrishayes
Contributor III
Contributor III

If you are using Qlik Sense, it gives you the option when you set up the data connection to choose Windows authentication or user name.