SQL Server Management Studio 2005 - RunAs

by michaellotter 24. September 2008 00:07

I've been heads down in work this last month and I've barely seen my wife in the process Frown but I've learned a lot and yesterday I picked something up that I thought was worth sharing.  When I was using Windows XP I sometimes had to run programs with the "RunAs" command so I could run them as a different user than myself.  One of my current projects required this for SQL Server Management Studio 2005 but I couldn't find any way to do this.  After a lot of frustration I found somebody mentioning RunAs command from the command prompt.  When I saw this I thought there was still hope and after reading the RunAs little help section and trying a couple different things I was successful at launching SQL Server Management Studio 2005.  Below is what I ended up using to make it work.

runas /noprofile /netonly /user:domain\username "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe" 

Hope this helps somebody as it helped me.

Cheers,
Michael 

Tags:

SQL Server 2005

About me

Michael Lotter
B&R Business Solutions
SharePoint Solution Architect
MCTS
More...

 

SharePoint Saturday

SharePoint Saturday is a free event open to the public and is focused on all aspects of SharePoint and related Microsoft Office technologies.  
  

 

 

 

 

 

 

Calendar

<<  March 2010  >>
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar

RecentComments

Comment RSS