5

It seems that I have the same problem as Yasser in this post

I cannot add a new Server Role "SQL Server 2008 R2"

but I am running SQL Server 2014.

Basically when I right click on Server Roles I only get a menu with three options, "Start Power Shell, Reports, Refresh".

The command CREATE SERVER ROLE works. I am logged in as "sa". Any advice would be really helpful.

Thank you.

5
  • 3
    What version of Management Studio are you using (from Help > About)? Is it the Express edition? Jan 18, 2016 at 22:56
  • Yes it is the Express Edition and the version is 12.0.2. Does the express edition have limited functionality?
    – Saloom
    Jan 18, 2016 at 23:10
  • And are you sure the engine you are connecting to is 2012 or better? What is SELECT @@VERSION;? Can you show a screen shot of Object Explorer that includes the server/version? Jan 18, 2016 at 23:34
  • Right click on "security" and select "new" then "server role".
    – Peter R
    Jan 26, 2017 at 14:35
  • FWIW I also see this problem (when connecting to Express Edition instances only). Jan 26, 2017 at 16:55

1 Answer 1

2

This is a known bug in Management Studio, and has existed since at least SQL Server 2012. Unlike other missing things in Management Studio (like SQL Server Agent), this has nothing to do with the version or edition of Management Studio you're using, but rather the edition of SQL Server that Object Explorer has connected to. Here's confirmation from one of the lead SSMS devs:

enter image description here

You will need to use T-SQL for this functionality until they fix it (which I think after 2016 SP1 they'll need to do a full audit of any instance-specific filtering or restrictions).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.