While building a lab cluster, I could not start SQL Service: Error 17172, SNIInitialize() failed with error 0x2. Here is what the ERRORLOG showed and the fix.
SQL SERVER – SQL Service Not Starting in Cluster- The System Cannot Find the File Specified
A clustered instance would not fail over because the SQL Service on Node2 did not start: the system cannot find the file specified. Here is what we found.
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 – Startup Error – Your SQL Server Installation is Either Corrupt or Has Been Tampered With
After I broke a named instance in my lab, sqlservr.exe gave a startup error: your installation is either corrupt or has been tampered with. Here is the fix.
How to Auto Start SQL Server After a Crash
To auto start SQL Server after a crash, set the Windows service to restart itself on failure, and set its start mode to Automatic for a reboot. This post checks what a server has today with T-SQL and the sc command, sets the three places that matter, and shows how to find the cause of the crash. A restart gets the server running again, and it doesn’t find the cause.
Move the Master Database to a New Location in SQL Server
To move the master database, change its startup parameters in SQL Server Configuration Manager, stop SQL Server, move the files and start it again. This post explains why ALTER DATABASE can’t move master, reads the current paths with T-SQL, and lists the steps and the permission check that stops most failed moves. It also says what to do when the instance won’t start afterwards.
SQL SERVER – Automatic Startup Not Working for SQL Server Service
After a power failure, a client’s SQL Server service stayed down even though it was set to Automatic. Here is why automatic startup can fail and what to check.