When I start SQL Server Management Studio 2008, I get an error that’s been around forever and is documented here. One of the suggestions to fix it that actually worked was to start SSMS with Run as Administrator.
So I modified the properties of the shortcut to always run it as the administrator. The only annoyance is that I get a prompt every single time asking whether I really want to do it.
Is there a way to tell just this one program (SSMS) to not pop up the prompt, while keeping this behavior for other apps?
Solution:
Read the following forum post: How to disable the User Account Control Prompt for certain application
It tells you basically, that you have to download Microsoft Application Compatibility Toolkit 5.6 and create a custom App fix database where you assign the ‘RunAsAdmin’ fix to the exe. I tried it and it worked for me I thought it worked.
Another way
… is described inHow to Create a Elevated Program Shortcut without a UAC Prompt
This solution requires you to create a ‘scheduled’ task for the application and running the app means triggering the task. (For a detailed description with screenshots see the link):
Run the Task Scheduler via
taskschd.msc
and Create Task…- Tab General: Give the name
[Name]
to the new task, check Run with highest privileges and choose “Windows 7, Windows Server 2008 R2” from the dropdown list Configure for - Tab Actions: Add New… Action Start a program with Program/script =
%windir%System32cmd.exe
and Add arguments =/c start "[Name]" "C:Program FilesSampleProgram.exe"
. Substitute[Name]
with the name of the task (step 1) and the fill in the path to the program which should run elevated. - Tab Conditions: Uncheck Stop if the computer switches to battery power first, and then uncheck Start the task only if the computer is on AC power
- Tab General: Give the name
Create a new shortcut oh the desktop or wherever with the following target location
schtasks /run /tn "[Name]"
Once again,
[Name]
is the name of the task (step 1)!Run as Minimized if you don’t want the command window to flash up.This shortcut and task can only be created and work while logged in as an administrator account.It’ll not work in a standard user account.