Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Document config for connecting to Windows domain server with integrated authentication #114

Open
BlueDrink9 opened this issue Nov 16, 2022 · 1 comment

Comments

@BlueDrink9
Copy link

I have a microsoft sql server I need to connect to using Windows authentication.
With the MS sql server plugin in VSCode, this works by specifying ServerName\DBinstance and specifying "integrated" for the authentication type.

The mssql go driver explicitly supports using windows authentication

However, I cannot tell how to configure sqls to take advantage of that. Using the above as the dataSourceName results in a call to localhost for the server, which is incorrect.

It would be great to get more clarity on how to do this please.

@jhamm
Copy link

jhamm commented Nov 11, 2024

I found the answer on StackOverflow by @akvalley
copying directly from SO:

The connection string for Windows Authentication looks like this:

"server=localhost;user id=;"

The value for "user id" parameter is blank and the "password" parameter is not used in the connection string.

and his answer also links to the issue denisenkom/go-mssqldb#475

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants