Skip to content
This repository has been archived by the owner on May 7, 2024. It is now read-only.

How to connect when connection requires specifying a 'domain' connection property #260

Open
nneul opened this issue Aug 10, 2021 · 5 comments

Comments

@nneul
Copy link

nneul commented Aug 10, 2021

When using JDBC client for MSSQL, in order to successfully authenticate as a domain user from a non-domain system (in particular using dbeaver client which uses 'Microsoft JDBC Driver for SQL Server' -- I have to add a connection property of "domain=my.domain.com", and authenticate as just the plain userid and password with "NTLM" chosen as the authentication scheme. No combination of using DOMAIN\userid or userid@domain or similar will function otherwise.

Is there some way to do something similar to this with mssql-scripter? It just gets a fairly generic login failed with every combination I've tried.

Error details:

Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server SERVER. ---> System.Data.SqlClient.SqlException: Login failed for user 'USERID'.
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)

To my knowledge the SQL server installation is a fairly vanilla install with AD integrated authentication. I am attempting to authenticate with an AD userid in the same domain as the database server.

@KevinBott
Copy link

@nneul Did you have any luck getting connected? I'm also trying to use NTLM authentication scheme.

@nneul
Copy link
Author

nneul commented Dec 8, 2021

@KevinBott No, never did get anywhere on this.

@fpauser
Copy link

fpauser commented Oct 27, 2022

Any news on this? Would be helpful being able to connect using NTLM...

@KevinBott
Copy link

@fpauser No news. I'm not hopeful that it will be supported unless someone from the community figures it out. Major updates to the dev branch (from key contributors) stopped in mid-2018.

@fpauser
Copy link

fpauser commented Oct 27, 2022

@KevinBott Thanks for pointing out.

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

No branches or pull requests

3 participants