How to Run an app as Administrator without the prompt?

Question

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?

Answer 1

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

Answer 2

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.

Answer 3

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.