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:47:37
|
| Hi,When user tried to connect to sql server, gets following error:SQLState '28000'SQL Server Error: 18456Micorsoft SQL Server Native Client 10.0 SQL Server login faile for user abc\xyz.Connection failed:SQLState '42000'SQL Server Error: 4064Micorosft SQL server Native Client 10.0 SQL Server cannot open user default database. Login failed.How to resolve this issue, please help.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-11-02 : 18:07:55
|
| On SQL Server side, I changed default database for that group as master. But still error. Actually user is testing in ODBC Interface. User is member of AD group and that group have permissions on database. |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-11-02 : 18:24:19
|
| Have you tried changing the database explicitly in the connection string?=================================================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 |
Posted - 2012-11-02 : 18:47:41
|
| Are permissions specifically denied for that user or any group that user belongs to?-Chad |
|
|
|
|
|
|
Connection failed