SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


I want to have SQL Server Mgmt Studio to have the ability to run as a different Windows user. Some...


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.

Author
Message
rayfernandez90027
rayfernandez90027
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 47
How do I do that? What causes the differences?
rayfernandez90027
rayfernandez90027
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 47
Using SQL 2005
Orlando Colamatteo
Orlando Colamatteo
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14861 Visits: 14396
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
durai nagarajan
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1605 Visits: 2775
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
Orlando Colamatteo
Orlando Colamatteo
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14861 Visits: 14396
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
durai nagarajan
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1605 Visits: 2775
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
Orlando Colamatteo
Orlando Colamatteo
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14861 Visits: 14396
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
SQLServerCentral.chrisdersley
SQLServerCentral.chrisdersley
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search