Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I want to have SQL Server Mgmt Studio to have the ability to run as a different Windows user. Some has it while others has run as Administrator. Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 7:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 7:31 PM
Points: 2, Visits: 47
How do I do that? What causes the differences?
Post #1419270
Posted Tuesday, February 12, 2013 7:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 7:31 PM
Points: 2, Visits: 47
Using SQL 2005
Post #1419271
Posted Wednesday, February 13, 2013 4:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 25, 2014 8:04 PM
Points: 7,141, Visits: 12,768
I 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.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419403
Posted Thursday, February 14, 2013 12:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 25, 2014 10:37 AM
Points: 1,058, Visits: 2,698
opc me too confused

if you launch as administrator will it make any difference in SSMS working method? i dont think so.


Regards
Durai Nagarajan
Post #1419845
Posted Thursday, February 14, 2013 6:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 25, 2014 8:04 PM
Points: 7,141, Visits: 12,768
What 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.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1420033
Posted Thursday, February 14, 2013 7:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 25, 2014 10:37 AM
Points: 1,058, Visits: 2,698
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.

registered servers again will depend on the servers accessed right? , is there any other defference?


Regards
Durai Nagarajan
Post #1420061
Posted Thursday, February 14, 2013 7:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 25, 2014 8:04 PM
Points: 7,141, Visits: 12,768
durai nagarajan (2/14/2013)
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.

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.

registered servers again will depend on the servers accessed right? , is there any other defference?

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.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1420067
Posted Friday, February 15, 2013 1:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 24, 2013 11:11 PM
Points: 2, Visits: 7
Try creating a shortcut on your desktop to runas.exe (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.

runas.exe /user:xDomain\xUserName /savecred "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

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 | Shortcut
Type or paste in the link exactly as it appeared in the DOS window.
Click Next
Rename 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.
Post #1420424
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse