Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I start SQL Server Management Studio 2008, I 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?

share|improve this question

3 Answers 3

up vote 2 down vote accepted

I doubt it. If such a thing were possible, every piece of malware would set that option, which would defeat the whole purpose.

share|improve this answer
3  
It is possible. Take a look f3lix's answer. –  DRAX Jun 16 '13 at 15:37

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.

share|improve this answer
    
Also see the following answer on Arcade.se gaming.stackexchange.com/q/42747/11789 –  Joshua Drake Dec 13 '12 at 2:12
6  
f3lix's answer (2nd part) works for me. I believe this should be accepted answer. –  DRAX Jun 16 '13 at 15:36

You can't set this up for a single application. All you can do is turn off UAC altogether - which is not recommended. If you stop and consider it for a second, you're actually better off clicking a "yes" button once in a while, compared to a malware taking over your computer.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.