Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.
SQL SERVER – List Users with System Admin (sysadmin) Rights – Part 2
After my post on listing users with System Admin (sysadmin) rights, Chris Mangrum shared a better script that also covers CONTROL SERVER. Here it is.
SQL SERVER – List Users with System Admin (sysadmin) Rights
I List Users with System Admin membership before agreeing on the permissions for a health check. This query inspects visible principals.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication – SPN Issue
Login failed, untrusted domain, error 18452, and a cluster that would not fail over. The cause was an SPN. How to read the SPN messages.
SQL SERVER – FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller
A SQL Server machine was promoted to a domain controller and the service stopped starting. Why it broke, the workaround we used, and the real fix.
SQL SERVER – FIX: Msg 15150 – Cannot Alter The User ‘dbo’.
Deploying SharePoint, a client tried to change the dbo mapping and got Msg 15150: Cannot alter the user ‘dbo’. Here is why it happens and how to fix it.
SQL SERVER – AlwaysOn Availability Groups: Script to Sync Logins Between Replicas?
A script to sync logins between availability group replicas, keeping the SID so users do not orphan on failover. What to copy and what to check after.