debugsqlMinor
Cannot add new Server Role SQL Server 2014
Viewed 0 times
cannotnewsqlroleserver2014add
Problem
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.
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.
Solution
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:
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).
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).
Context
StackExchange Database Administrators Q#126570, answer score: 2
Revisions (0)
No revisions yet.