patternsqlMinor
Red Symbol on Server Roles
Viewed 0 times
symbolredrolesserver
Problem
I was RDP to one of my servers (SQL Server 2012 (SP4) Std Ed) and saw that the Server Roles had a red symbol (not a red x), but when I connect to that server through a VPN using MSSQL that red symbol doesn't show. I have been through MS knowledgebases and no explanation what so ever. Anybody knows what it means and how to remove this?
Solution
Zooming in on the icon it looks like a red push pin.
Searching specifically for red pin and management studio I found this thread which explains
If a principal is disabled, then it has a red arrow pointing down in
the icon ... Here you have a red pin icon and
this means you can't modify it. Since SQL Server 2014 we can create
user defined server role ... which
wasn't possible in SQL Server 2012 and lower version ... user defined
roles don't have a red pin and can be modified, while predefined
server roles do have a pin
One exception is that the permissions of the
In more recent versions of management studio it appears a lock icon is used for that instead.
Searching specifically for red pin and management studio I found this thread which explains
If a principal is disabled, then it has a red arrow pointing down in
the icon ... Here you have a red pin icon and
this means you can't modify it. Since SQL Server 2014 we can create
user defined server role ... which
wasn't possible in SQL Server 2012 and lower version ... user defined
roles don't have a red pin and can be modified, while predefined
server roles do have a pin
One exception is that the permissions of the
public role can be altered (but membership can't). For all other pre-defined server roles the reverse is true.In more recent versions of management studio it appears a lock icon is used for that instead.
Context
StackExchange Database Administrators Q#270006, answer score: 2
Revisions (0)
No revisions yet.