February 12, 2013 at 7:53 pm
How do I do that? What causes the differences?
February 12, 2013 at 7:53 pm
Using SQL 2005
February 13, 2013 at 4:54 am
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
February 14, 2013 at 12:42 am
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
February 14, 2013 at 6:53 am
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
February 14, 2013 at 7:35 am
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
February 14, 2013 at 7:43 am
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
February 15, 2013 at 1:31 am
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.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply