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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-12 : 18:34:03
|
| Torben Schou writes "I have the following problem.I have a NT user (Domain/NN) who is a member of 2 different NT groups (Domain/AA, Domain/BB), this groups has a login into the same SQL Instance but different default databases. The user self don't have his own login on the SQL Instance.I a running SQL Server 2005 SP1If the default database for NT group Domain/AA is offline or in recovery mode, the user if refused access to the SQL Instance is this pr design or a bug?Even if the other NT group Domain/BB has sysadmin rights the access is still refused.Is the a known work around to this problem?Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-09-12 : 18:35:25
|
| I would add Domain/NN to the SQL Server logins and assign a different default database, then grant them access to both DBs. |
 |
|
|
|
|
|
Login using integrated authentication and default database.