After a SQL Server cluster failover, SharePoint users could not open any page, though all SQL resources were online. Here is what we found and how we fixed it.
SQL SERVER – FIX – Error 1402 – Could not Open Key: UNKNOWN\Components – System Error 5 (Another Solution)
Installing KB3045311 failed with Error 1402, could not open key UNKNOWN\Components, system error 5. When my earlier fix did not help, this one worked.
SQL SERVER – FIX: Unable to Create Distribution Database on a UNC Share – Configure Distribution
With SQL Server on a UNC share, the Configure Distribution wizard refuses network paths for the distribution database. Here is how to create it anyway.
SQL SERVER – Unable to Start SQL After Patching – Database SSISDB is Enabled for Database Mirroring
After patching, SQL Server would not start. The SSIS hotfix script failed because database SSISDB is enabled for Database Mirroring. Here is the fix.
SQL SERVER – Event ID 1069 – Unable to Failover Clustered Instance to Another Node. Resource is not Loaded
My lab failover clustered instance would not move to the other node: Event ID 1069, resource is not loaded. Here is what the logs showed and the fix.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.
SQL SERVER – Error: 1067 – Unable to Bring Analysis Service Online in Cluster
A client could not bring the Analysis Service online in a cluster, and the logs only said Error 1067. Here is the systematic approach that found the cause.