A weird discovery regarding authentication via AD Group to SQL Server.

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply