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

[zbeauchemin]

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?

[isingh30]

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]

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]

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.