This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Impersonate Windows Credentials in SQL Server Management Studio?

Question
0

Sign in to vote

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

1

Sign in to vote
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
1

Sign in to vote
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

1

Sign in to vote
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
0

Sign in to vote
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
1

Sign in to vote
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