A reader could not recycle ERRORLOG files with sp_cycle_errorlog. The ERRORLOG itself showed the reason. Here is what went wrong and how to fix it.
SQL SERVER – Error: 26014, Severity: 16. Unable to Load User Specified Certificate
After a client changed the SQL Server certificate, the service would not start: Error 26014, unable to load User Specified Certificate. Here is how we fixed it.
SQL SERVER – Setup Screen Not Launching While Updating a Patch
Double clicking a SQL Server patch just flashed a window and vanished. SqlSetup.log in the %temp% folder showed why the Setup Screen was not launching.
SQL SERVER – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
Event ID 107 says the Report Server Windows service cannot connect to the report server database. Here is how I fixed it.
SQL SERVER – Network Name resource fails to come online in a Windows Server 2008 R2 Failover Cluster
After adding a new disk, a client’s cluster Network Name resource would not come online in a Windows Server 2008 R2 Failover Cluster. Here is what we found.
SQL SERVER – Drive Space Full Due to MDMP Files
A client’s C drive kept filling up, and the transaction log was not to blame. SQL dump files were. Here is what caused this Drive Space Full issue.
SQL SERVER – Identifying Database Default Locations for Data and Logs
Going back to basics can still teach you something new. Here are ways to identify the Database Default Locations for data and log files in SQL Server.