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.
How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142
SQL Server logins follow Windows password rules by default. If a login has it turned off, here is a simple script to Enforce Password Policy again.
SQL SERVER – Login Failed – Error: 18456, Severity: 14, State: 38 – Reason: Failed to Open the Explicitly Specified Database
Error 18456 State 38: failed to open the explicitly specified database. The login worked and the database did not. The four usual causes.
SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated
SCOM warned that SQL Server cannot use Kerberos because the Service Principal Name (SPN) is missing. Here is how I checked and fixed the SPNs for a client.
SQL SERVER – FIX: RequireKerberos Error During SQL 2008 Installation on Windows 2008 R2 Cluster
A client installing SQL Server 2008 on a Windows 2008 R2 cluster hit a RequireKerberos error near the end of setup. Here is the cause and the fix.