My beloved developer team is trying to connect MSSQL instance with third party tool ( unix platform) with domain user and they got below error.
DEV team need to use connect-string as per the authentication used for DB connection.
For DBA side we need to verify :1. Check windows user is create and valid permission to access the database.2. SQL instance should be in mixed mode.
References :http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx
http://kristofmattei.be/2013/04/12/serverconnection-and-login-failed-for-user-reason-attempting-to-use-an-nt-account-name-with-sql-server-authentication/
No comments:
Post a Comment