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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » General » A weird discovery regarding authentication...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Andrew Miller-489894

Posted Thursday, October 25, 2012 9:06 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:03 AM
Points: 59, Visits: 304

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 »

Permissions