SNIInitialize() failed with error 0x2 – Jocha


I’ve set up a Windows 2008 R2 server fully patched with SQL 2008 R2 SP1 CU6 server with an instance called SCCM.
After running the pre-req check from the SCCM 2012 setup my database breaks.

When I try to start the service from SQL Server Configuration Manager it gives me; The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.


The event log gives me this error;
Error: 17172, Severity: 16, State: 1.
SNIInitialize() failed with error 0x2.

and:
The SQL Server (SCCM) service terminated with the following error:
The system cannot find the file specified.

Unless you’re running SQL Cluster this will likely fix your problem:

  • Shutdown SQL service from SQL Server Configuration Manager.
  • Remove/rename the “Cluster” key from the following location:
  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.Instance_Name\Cluster
  • Start the service again.