Open Microsoft SQL Server Management Studio on Windows Server 2008 box
As you may already noticed, when working with Windows Server 2008, there are a lot of nuances we need to pay attention like if you are trying to open Microsoft SQL Server Management Studio, you will get an error like below even though the account you use has the admin right on SQL
What we need to do is to use Run As Administrator to start SQL Server Management Studio to bypass that error!