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 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

SQL Server 2005

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

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.  
 
Saturday, January 10th, 2009 
 
Saturday, February 7th, 2009 
 
Saturday, February 21st, 2009 
 

Calendar

<<  January 2009  >>
MoTuWeThFrSaSu
2930311234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar

RecentComments

Comment RSS