Can’t create an Always On listener? On three clusters, Event ID 1212 said the attempt to locate a writeable domain controller failed. I walk you through the fix.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 2
Part 2 of my series on the MSCS cluster verification errors rule in SQL Server setup: another cause we found in Detail.txt during install or AddNode.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 1
Installing a SQL Server clustered instance failed the Microsoft Cluster Service (MSCS) Cluster Verification rule. Part 1 covers the verification report cause.
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 – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
An LDAP query through a linked server worked in one domain but failed in another with Msg 7399 from the ADsDSOObject provider. Here is the fix.
SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource
Installing a second SQL Server 2012 instance on my Windows cluster failed: the cluster resource ‘SQL Server’ could not be brought online. Here is the fix.