Small Business Susan

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.