Menu items disabled in management studio for SQL server 2008

After connecting to report server on windows 2008, I had menu items disabled in management studio. I could not create, modify roles and other actions. Solution was to explicitly run Microsoft SQL server management console as administrator. This solved my problem

Advertisements