Skip to content

windows auth #694

Closed
Closed

Description

@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.

Activity

  1. github-actions commented on Jul 31, 2026

    @github-actions

    Hi ak (@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!

  2. jahnvi480 commented on Jul 31, 2026

    @jahnvi480
    Contributor

    ak (@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;

  3. added
    questionFurther information is requested
    area: connectivity-authConnection lifecycle, Entra/SP/NTLM auth, tokens, TLS, conn-string parsing, Fabric endpoints.
    and removed
    triage neededFor new issues, not triaged yet.
    on Jul 31, 2026
  4. arkdvd commented on Jul 31, 2026

    @arkdvd

    Works!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

area: connectivity-authConnection lifecycle, Entra/SP/NTLM auth, tokens, TLS, conn-string parsing, Fabric endpoints.discussionquestionFurther information is requested

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions