HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Red Symbol on Server Roles

Submitted by: @import:stackexchange-dba··
0
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 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.