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.
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