Post reply

NT groups and default databases

  • August 13, 2003 at 2:58 am

    #83040

    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

    #469698

    Thats an interesting question - hopefully someone will have the answer. I avoid the issue entirely:

    http://www.sqlservercentral.com/columnists/awarren/settingadefaultdatabaseforyourlogins.asp

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

  • August 14, 2003 at 8:37 pm

    #470049

    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

    #558150

    This exact question recently came up for me as well. Does anyone have any additional information on this subject?

Viewing 4 posts - 1 through 4 (of 4 total)

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