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 – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638
A customer’s SQL Server 2017 install kept failing with “VS Shell installation has failed with exit code 1638”. Here is what caused it and how we fixed it.
CPerIndexMetaQS::ErrorAbort: Too Many Dumps From Index Corruption
CPerIndexMetaQS::ErrorAbort in a stack dump points to index corruption in one of your databases. A reader had too many dumps, and the ERRORLOG and DBCC CHECKTABLE showed which index was bad. Here are the two repair options and why backups matter.
Msg 41379: Restore Fails on Insufficient Memory in the Default Resource Pool
Msg 41379 stopped a restore because the default resource pool had insufficient memory for a database with In-Memory OLTP tables. We raised the memory available to the default pool to 90 percent, and the error disappeared.
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.