August 13, 2003 at 2:58 am
Hi all, hope someone can help on this one. Sql 2000 sp3a, created 2 NT groups and granted access to sql server, each sql login(nt group) was allocated a different default database. A single NT login has been granted NT access to both NT groups. My question is when this NT login connects to SQL Server which default database is he connected to, is it random, based on sid or what? Could someone explain what process SQL Server goes through when authenticating an NT group /login? Thanks in advance.
August 13, 2003 at 3:48 am
Thats an interesting question - hopefully someone will have the answer. I avoid the issue entirely:
http://www.sqlservercentral.com/columnists/awarren/settingadefaultdatabaseforyourlogins.asp
Andy
August 14, 2003 at 8:37 pm
Hmm, no response as yet. I agree that getting it right from the app is the way to go, but curiosity as to what hapens under the covers still remains. Some testing I have done indicates that NT plays a major part in this. The order in which the NT groups and then login is added to the groups seems important in the sequence that SQL Server determines its ordering of group selection. Any other views are most welcome.
May 11, 2005 at 10:28 am
This exact question recently came up for me as well. Does anyone have any additional information on this subject?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply