Off the top of my head I'm guessing something related to a policy issue that is configured for the server. The DB icon shows the state of the server itself (and any WMI errors) so I believe the server itself is fine but there is a problem with something else. When you mouse over it does it show anything useful? Have you looked in your SQL Server error logs to see if it is showing errors?
Strange red icon near server istance
Alen Cappelletti
891
Reputation points
Hi...
I really don't know what the red script icon is (as in error) next to my instance name. Can anyone explain the meaning?
Thanks Alen
Accepted answer
1 additional answer
Sort by: Most helpful
-
Cris Zhan-MSFT 6,601 Reputation points
2021-04-06T03:25:55.017+00:00 Hi,
The icon shows policy violation.
For failed policies, Object Explorer indicates a critical health warning as a red icon next to the target and the nodes that are higher in the Object Explorer tree.
A similar post.
https://stackoverflow.com/questions/5896910/sql-server-management-studio-icon-meaning