Wednesday, June 24, 2009

The server principal "domain\windowsuser" is not able to access the database "DATABSE" under the current security context.

The server principal "domain\windows user" is not able to access the database "DATABSE" under the current security context.
This will normally happen when ODBC Datsource in the ODBCAD32 is configured to use "
With Integrated Windows Authentication" mode of authentication to the sql server.
The reason being that the domain\windows user is not added in the list of logins under the security tab of the sql server.
So the solution is to change the authentication type to "
With SQL Server authentication using a login ID and password entered by the user".
Sometimes you cannot change the authentication from former to latter,especially when you login as a non-admin user.In this case you need to login with admin user and change the authentication type.

No comments: