User is member of AD grop and that group have permission on database. When this user tried to connect database through ODBC connection he gets following error and cannot connect:
"Microsfot SQL Server Native client version 10.50.4000). Login failed for user 'xxx\1234'. Micorsoft SQL Server native client 10.0.] SQL Server cannot open database "abc" requested by the login. The login failed. TEST FAILED."
Is the Login "xxx\1234" mapped to a User in the database? Do the Login and the User have the same SID?
================================================= We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
look at their default database, they mave have access to databaseA, but when their login was setup the default may be something they do not have access to
SQL Server ODBC Data Source Test Failed
Posted - 11/02/2012 : 16:21:24
