Post reply

Windows Authentication using SSMS

  • September 23, 2009 at 7:43 am

    #156248

    Is there a way to change the windows login account from the Windows logged in user to a different account. I am looking to be able to change the account because the logged in user does not have local admin rights to the server but has Remote Desktop access.

    Thanks

    Aaron

    Aaron
    MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
    https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard

  • September 23, 2009 at 7:52 am

    #1057516

    I do not think it is possible. But I am not sure why you need to be a local admin to connect to the DB using SSMS?

    -Roy

  • September 23, 2009 at 7:55 am

    #1057522

    If you wanted to restart the agent service you need to be a local admin or use the service account as the login to ssms.

    Aaron
    MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
    https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard

  • September 23, 2009 at 8:05 am

    #1057531

    You can start SSMS with the runas option and then use another windows login.

    [font="Verdana"]Markus Bohse[/font]

  • September 23, 2009 at 8:09 am

    #1057532

    Never thought of that,

    thanks

    Aaron
    MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
    https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard

  • September 23, 2009 at 8:18 am

    #1057538

    MarkusB (9/23/2009)

    You can start SSMS with the runas option and then use another windows login.

    Good one Markus. I never thought about that. But does the user have to be a local admin to restart the SQL Server Agent? I am not sure about that. The user that logs on to SSMS should have sufficient rights. As per BOL

    "Click SQL Server Agent in Object Explorer of SQL Server Management Studio to administer jobs, operators, alerts, and the SQL Server Agent service. However, Object Explorer only displays the SQL Server Agent node if you have permission to use it."

    -Roy

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

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