Windows Authentication Confusion

  • Hi,

    Today one the server ,i logged in with DB\xxx login.but when i execute

    select suser_name() , i got different result ( DB\yyy).

    how it can happened ?

    IS it some thing to do with Active Directory ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Maybe because your login name on the server is different from the user in the database?

  • Here DB stands for "DOMAIN" and XXX stands for my profile name . is there any chance that

    login and user can be different ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • The login name in sql can be different from the user name on the db, can you check it? It probably has nothing to do with AD.

  • No , this is same but i also tried to changes user name like

    i rename DB\XXX with BK but still select suser_name() gives DB\XXX

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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