Post reply

windows authentication for another user account.

  • June 15, 2010 at 2:56 pm

    #387162

    when I tried to connect to a sql server through management studio, I first got the log in screen.

    On the login window, I can enter server name, and then choose either windows authentication or sql authentication.

    My question is: for windows authentication, it always picks up whatever username I log in for the computer, but is there a way that I change to another windows account?

    for example, I login my local computer using my regular login ame JSmith.

    But when I tried to connect to a remote sql server using that account, I got access denied message.

    I would like to change the windows authentication using my another admin account -JSmith-Adm, then I should be able to connect to that server.

    How can I change that?

    Thanks

  • June 21, 2010 at 11:23 am

    #1182887

    If you are using Windows XP, you can right click on the Managment Studio and click on "Run As...". Click on the option "The following User" and enter your credentials.

    ---------------------------------------------------
    Thanks,
    Satheesh.

  • June 21, 2010 at 11:25 am

    #1182889

    I'm using windows 7, there is not that option.

    Thanks

  • June 21, 2010 at 12:07 pm

    #1182905

    Pop the menu in Win 7, hold down shift, right click SSMS. You'll get a run as different user. See the image attached.

  • June 21, 2010 at 12:09 pm

    #1182906

    Great, that helps a lot!

    Thanks!

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

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