Post reply

SQL Authentication - Windows Login

  • August 7, 2007 at 5:18 am

    #69667

    Hi.

    I´m running 5 SQL 2000 servers all in Mixed mode authentication, mostly due to historical reasons (many applications are hard programmed using SQL logins.)

    I´m starting to make these accounts abselute so I can set all 5 servers to Windows Authentication - Untill then I have to live with both types of log ins.

    And know to my question

    How do I log in to Querry Analyzer using a different Windows account, than the one I´m logged on to the machine? I need to check security settings/Access on different NT accounts...

     

  • August 7, 2007 at 6:08 am

    #725098

    Torben

    Right-click on your Query Analyzer icon and choose Run As.  You can then enter the security details for the account you want to connect as.

    John

  • August 7, 2007 at 11:18 pm

    #725349

    Hi John.

    Many txs for the answer 🙂

    It worked like a charm - but I had hoped that I could enter the credentials as a SQL login..

    But I´ll stick to the "Run As"

  • August 8, 2007 at 5:02 am

    #725392

    Torben

    Do you mean enter the credentials in the same way as a SQL login?  I don't think that's possible.

    John

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

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