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 |
|
Balage_Baju
Starting Member
8 Posts |
 Posted - 2009-03-04 : 08:39:24
|
| Hi All,We are getting the following error when we try to connect with SQL Server 2005 SP2. "Cannot open user default database. Login failed.Login failed for user '<user name>'. (Microsoft SQL Server, Error: 4064)"We are getting this issue only when we try to access SQL Server through "Windows User Groups". If we add the individual login accounts under Security tab then we are able to connect with SQL Server without any issues. We changed the default database name to "Master" for all the Windows User Groups, but still we are getting the same issue. Please provide your suggestions to fix this issue...Thanks,Balaji. |
|
|
|
|
|
Authentication Issue for Windows Groups