InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:39:00 GMT20http://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxTry creating a shortcut on your desktop to [b]runas.exe[/b] (not the studio executable).First open a Command prompt and try the following command (you may have to change the path slightly for your version of SQL), but change the xDomain\xUserName to the one you want to use.You may want to remove the /savecred option to increase security by entering the password every time the application starts. It'll always ask for the password the first time.[b]runas.exe /user:xDomain\xUserName /savecred "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"[/b]If Management studio starts up, note the username in the Connect As dialog to make sure, otherwise correct any errors in the command and try again. Make sure to use double quotes if there are spaces in the path to the studio executable.Once all is working to your satisfaction...Create a shortcut by right-clicking the desktop | New | ShortcutType or paste in the link exactly as it appeared in the DOS window.Click NextRename the link to something useful and click finish.Dbl-click the shortcut the next time you want to open Studio as that user.ps. You can change the shortcut's icon, by going into the Properties and clicking the change icon button.Paste in the path to your Studio and choose an icon from the list.Fri, 15 Feb 2013 01:31:16 GMTSQLServerCentral.chrisdersleyhttp://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspx[quote][b]durai nagarajan (2/14/2013)[/b][hr]working method like connection in sql authentication any way we have to give user and pwd credentials, windows authentication hope wont work on adminstrator access.[/quote]A connection method of Windows Authentication may or may not work when running SSMS as Administrator. Just like any other Windows account it will depend on whether there is a Login for it in the SQL Server instance. SQL Server Authentication is always an option is the instance is setup to allow it.[quote]registered servers again will depend on the servers accessed right? , is there any other defference?[/quote]Registered Servers is a personal manually maintained list of servers you can create in SSMS so it is stored per user. See the View > Registered Servers menu.Thu, 14 Feb 2013 07:43:14 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxworking method like connection in sql authentication any way we have to give user and pwd credentials, windows authentication hope wont work on adminstrator access.registered servers again will depend on the servers accessed right? , is there any other defference?Thu, 14 Feb 2013 07:35:50 GMTdurai nagarajanhttp://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxWhat do you mean by "working method"?SSMS will function as usual, but it will be "running as" the Administrator so will be setup using the Administrator's preferences, e.g. their Registered Servers list, etc.Thu, 14 Feb 2013 06:53:38 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxopc me too confused if you launch as administrator will it make any difference in SSMS working method? i dont think so.Thu, 14 Feb 2013 00:42:53 GMTdurai nagarajanhttp://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxI am not sure I understand this comment: "Some has it while others has run as Administrator."If you want to run a program as another user right-click the shortcut you would use to open the program while holding down the Shift key then click either 'run as administrator' or 'run as different user', whichever is relevant to your situation.Wed, 13 Feb 2013 04:54:17 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxUsing SQL 2005Tue, 12 Feb 2013 19:53:46 GMTrayfernandez90027http://www.sqlservercentral.com/Forums/Topic1419270-146-1.aspxHow do I do that? What causes the differences?Tue, 12 Feb 2013 19:53:15 GMTrayfernandez90027