Why does the SQL Server Sysadmin role members check report a blue asterisk when I scan the computer?
In many installations (particularly in enterprise environments) it is useful for administrators to distinguish between the roles of the operating system administrator and the SQL Server administrator. In such scenarios it might be useful to remove the local Windows administrators’ membership in the SQL Sysadmin role. However, instances of WMSDE currently are required to have the local Windows administrators’ membership in the SQL Sysadmin role, and therefore need to be exempt from this check. WMSDE is a derivative of MSDE meant for use by Windows Server 2003 operating system components, such as Windows SharePoint Services. Check the documentation accompanying the application for information on the minimum level of privileges required.
