locked
Impersonate Windows Credentials in SQL Server Management Studio? RRS feed

  • Question

  • I need to connect to a SQL server at work, which uses Windows Authentication. I know I could join my laptop to the domain, but I was also wondering if there was anyway to impersonate Windows Credentials in SQL Server 2012 Express' Management Studio.

    Sunday, February 3, 2013 3:23 PM

Answers

  • When your laptop isn't member of the domain then: No.

    Otherwise you could start SSMS with a different domain user account.


    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Tuesday, February 5, 2013 10:16 AM
    • Marked as answer by Fanny Liu Monday, February 11, 2013 8:33 AM
    Sunday, February 3, 2013 4:01 PM
  • Hi,

    Join your laptop to domain,Windows Credentials in SQL Server 2012 Express' Management Studio will start working.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @Waqas_m1
    Linked In: http://www.linkedin.com/in/waqasm1

    • Proposed as answer by Waqas M Wednesday, February 6, 2013 7:49 AM
    • Marked as answer by Fanny Liu Monday, February 11, 2013 8:33 AM
    Monday, February 4, 2013 1:01 PM

All replies

  • When your laptop isn't member of the domain then: No.

    Otherwise you could start SSMS with a different domain user account.


    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Tuesday, February 5, 2013 10:16 AM
    • Marked as answer by Fanny Liu Monday, February 11, 2013 8:33 AM
    Sunday, February 3, 2013 4:01 PM
  • Cool.

    I was able to start the VPN, join the domain, then start SSMS.exe with the runas /user: command. Joining the domain did create a new user account on the PC, but I just removed it.

    Things are working great form my local user now.

    Thanks!

    • Marked as answer by Fanny Liu Monday, February 11, 2013 8:33 AM
    • Unmarked as answer by Fanny Liu Monday, February 11, 2013 8:33 AM
    Sunday, February 3, 2013 5:46 PM
  • Hi,

    Join your laptop to domain,Windows Credentials in SQL Server 2012 Express' Management Studio will start working.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @Waqas_m1
    Linked In: http://www.linkedin.com/in/waqasm1

    • Proposed as answer by Waqas M Wednesday, February 6, 2013 7:49 AM
    • Marked as answer by Fanny Liu Monday, February 11, 2013 8:33 AM
    Monday, February 4, 2013 1:01 PM