windows auth

[akommera]

Anyone here tried connection to on-prem sql server with windows auth, if so what should be the connection string.

I tried with
1.server=XXXXX.com,1234;Database=XXXX;Authentication=ActiveDirectoryDefault and no luck

2.server=XXXXX.com,1234;Database=XXXX;TrustServerCertificate=yes
errors as Invalid auth specification; DBCC Error: Login failed for user.

3.server=XXXXX\dbname;Database=XXXX;TrustServerCertificate=yes
errors as Invalid auth specification; DBCC Error: Login failed for user.

[github-actions]

Hi @akommera, thank you for opening this issue!

Our team will review it shortly. We aim to triage all new issues within 24-48 hours and get back to you.

If you have additional information to share, please feel free to update the issue.

Thank you for your patience!

[jahnvi480]

@akommera While using Windows auth you do not have to provide Authetication keyword.
Make sure your connection string looks like
Server=YOUR_SERVER_NAME;Database=YOUR_DB_NAME;Trusted_Connection=yes;Encrypt=yes;TrustServerCertificate=yes;

[arkdvd]

Works!