Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-11-02 : 16:21:24
|
| Hi,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."Any help?Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-11-02 : 18:26:38
|
| 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 |
 |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
tcronin@cmsstl.com
Starting Member
7 Posts |
Posted - 2012-11-05 : 14:21:51
|
| 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