Post reply

What login is in use?

  • January 19, 2011 at 3:52 am

    #230570

    hello,

    I'm using Windows authentication to connect an SQL 2008 R2 SQL server. I've created two logins based upon two different windows groups (these are groups of my domain). Here comes my question: If an user belongs to the two groups, what login it will use by default? Can I specify in the string connection the login that I want to use?

    Thanks for advance

  • January 19, 2011 at 4:38 am

    #1275194

    Whatever account the user is logged in at the time, will be passed to the SQL Server for authentication by default, with windows authentication (pass through).

    You can of course mask this using a stored connection or odbc or similar, and specify a connection account.

  • January 19, 2011 at 4:43 am

    #1275200

    This will also probably help answer your query in regards to the 2 AD groups;

    http://www.sqlservercentral.com/Forums/Topic368179-6-1.aspx#bm951922

    The user will normally retain the highest level of permission I believe, in that scenario, although it is best-practise to avoid any permission conflicts.

  • January 25, 2011 at 3:23 am

    #1277697

    Ok, thank you for the help.

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

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