How do you start a database in a single user mode when there is corruption? Here are simple steps in SQL Server Configuration Manager, one by one.
SQL SERVER – Initializing the FallBack Certificate Failed With Error Code: 1, State: 20, Error Number: 0
After a service account password change, SQL Server would not start: Initializing the FallBack certificate failed, error code 1. Here is the fix.
SQL SERVER – Unable to Start Service SQLSERVERAGENT on Server (mscorlib)
After moving the SQLAgent.OUT path, a client saw: Unable to start service SQLSERVERAGENT on server (mscorlib). Here is one cause of this error and the fix.
SQL SERVER – Event ID: 10028 – SQL Server Distributed Replay Client – DCOM was Unable to Communicate with the Computer
Event ID 10028 from the SQL Server Distributed Replay Client flooded a client’s event log and buried the data we needed. Here is how to stop the noise.
SQL SERVER – SQL Server Configuration Manager Error: 0x80010108 – The Object Invoked Has Disconnected From its Clients
SQL Server Configuration Manager gave error 0x80010108: The object invoked has disconnected from its clients. Here is one cause I could reproduce on demand.
![SQL SERVER - Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]](https://blog.sqlauthority.com/wp-content/uploads/2018/10/sscm-err-02.jpg){kind=small}
SQL SERVER – Unable to Launch SQL Server Configuration Manager. Error: Cannot Connect to WMI Provider. [0x80070422]
SQL Server Configuration Manager would not open on my VM: Cannot connect to WMI provider [0x80070422]. I share what caused it and how I fixed it.
SQL SERVER – How to Turn On / Enable Instant File Initialization?
This follow-up to my IFI posts shows how to turn on and enable Instant File Initialization when it is disabled, with a method that works for nearly every version.