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

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…

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