[There's a reason that Yoda is the unofficial mascot of SBS.  Size indeed matters not.] SBS 2008 and Run As Administrator - THE OFFICIAL BLOG OF THE SBS DIVA
Wed, Jul 30 2008 12:51 bradley

SBS 2008 and Run As Administrator

So on SBS 2008 you want to open up the SBS 2008 monitoring database... okay so "I" wanted to... and when you click on the SQL Server management express you get this lovely error when trying to open up the SQL SBSMonitoring instance.

So the trick is to open up that SQL management tool with Run As Administrator.  Duh.

Okay so because it's clear that I'm lazy and can't remember which ones RunAs and which ones don't, I want to build a shortcut on the desktop that prechecks that.  Start, Programs find the SQL management program and right mouse click and "send to" "desktop, create shortcut" as the first step.  Now that we have the icon on the desktop.

Right mouse click on it and in the Compatibility tab, click on Run As Administrator and Apply

Now when you click on the ICON you will get a UAC prompt

And once you do that you can log into SQL instance for the SBSMonitoring

Remember the Forefront console needs this as well.

So if at first you get an error, try Run As Administrator.

Filed under:

# re: SBS 2008 and Run As Administrator

Wednesday, July 30, 2008 6:45 PM by Craig

lol UAC without a UAC prompt.

"Why should a program need administrator rights just to run?"

# re: SBS 2008 and Run As Administrator

Friday, August 01, 2008 1:21 AM by Bill

I prefer using Task Manager shortcuts to start APPs with elevated priviledges, No UAC Prompts at all!

How to run programs elevated without getting the UAC Prompt

www.winhelponline.com/.../run-programs-elevated-without-getting-the-uac-prompt