February 2, 2009 at 3:48 pm
We recently upgraded to Windows 2008 and are now having issues with users not being able to run SSMS. They are not administrators, and are forced to enter an administrator user name and password.
Would someone please confirm that it is possible for non-administrative users to use SSMS on Windows 2008? I don't believe our security guys will let us get rid of the UAC either.
I plan to watch one of the users actually attempt to run SSMS tomorrow...maybe they are trying to run it as administrator???
Your help is appreciated!
February 2, 2009 at 7:45 pm
A nasty solution is recorded here http://robbo.com/2008/11/26/sql-on-windows-server-2008-remember-to-run-ssms-with-elevated-privileges/
Basically, run SSMS in administrator mode.
--
Andrew Hatfield
February 3, 2009 at 2:02 pm
andrew.hatfield (2/2/2009)
A nasty solution is recorded here http://robbo.com/2008/11/26/sql-on-windows-server-2008-remember-to-run-ssms-with-elevated-privileges/Basically, run SSMS in administrator mode.
Andrew, thanks for the feedback. From what I can tell, this it telling me to run SSMS as an administrator. I am trying to find out if there is any way for a non-admin user to run SSMS (without running as administrator at all).
Any other thoughts?
February 3, 2009 at 2:25 pm
All, I was able to resolve this. I had updated the shortcut on my start menu to run SSMS as administrator. I found that running this would be benefit me as I ran into multiple situations where I was limited to what I could do solely on the fact that I was not running SSMS in administrator mode. I was not aware that changing the shortcut on my profile also updated it for every other user. Therefore, the non-admin users were being prompted to enter in an admin username & password.
To see if this is the case for you, you can have the user having issues try to run SSMS directly by double clicking the following; C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SQLWB.exe (application). My non-admin user was able to open SSMS fine here. That told me it was an issue with the shortcut.
To resolve this, I logged in as an admin and unchecked the open to run the shortcut as an administrator (right click shortcut, properties, Shortcut tab, advanced, uncheck run as administrator)
I am still learning about Windows 2008 🙂
February 3, 2009 at 10:34 pm
Sounds like your shortcut was in either C:\Documents and Settings\All Users\[Desktop|Start Menu]\ or C:\Users\All Users\[Desktop|Start Menu]\
--
Andrew Hatfield
February 4, 2009 at 1:26 pm
andrew.hatfield (2/3/2009)
Sounds like your shortcut was in either C:\Documents and Settings\All Users\[Desktop|Start Menu]\ or C:\Users\All Users\[Desktop|Start Menu]\
The location of the shortcut was the following:
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2005
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply