Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

A weird discovery regarding authentication via AD Group to SQL Server. Expand / Collapse
Author
Message
Posted Thursday, October 25, 2012 9:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 10:54 AM
Points: 60, Visits: 343
I ran into an issue today where an AD User was a member of two different AD Groups. Let's call this user User_A These AD Groups both had Logins on the same SQL Server. Let's call them Group_A and Group_B. Group_A is set to have Database_A as its default DB. Group_B is set to have Database_B as its default DB. When User_A connects to the SQL Server, its Default DB is shown as Database_B. My question is how is the default DB determined in this case?
Post #1377369
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse