I've been heads down in work this last month and I've barely seen my wife in the process 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
Tags:
SQL Server 2005
Powered by BlogEngine.NET 1.4.5.0 Theme by Mads Kristensen
Michael Lotter B&R Business Solutions SharePoint Solution Architect MCTS More...