Windows – How to Run an app as Administrator without the prompt

64-bitpromptssmsuacwindows 7

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?

Best Answer

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 in How 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...

    1. 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
    2. Tab Actions: Add New... Action Start a program with Program/script = %windir%\System32\cmd.exe and Add arguments = /c start "[Name]" "C:\Program Files\Sample\Program.exe". Substitute [Name] with the name of the task (step 1) and the fill in the path to the program which should run elevated.
    3. 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

  • 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.

Related Question