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
We are a bunch of volunteers and starting a brand new scheme in our community.
Your website offered us with useful info to work on. You've performed a formidable job and our whole community will be grateful to you.
We had this issue when we tried to install SCCM 2012 RTM in our production environment (Worked fine in the lab) and it took the instance down. We were installing this on a self contained SCCM server (Windows 2008 R2) with a separate SQL server (Windows 2008 R2/SQL 2008 R2 SP1 CU 6).
Exactly the same issue as here with the same errors. After logging a call with Microsoft the fix was to rename a registry key on the SQL server from Cluster to Cluster_Old located in the below location (We use mirror servers and not a cluster):-
HKLM -> Software -> Microsoft -> Microsoft SQL Server -> <SQL Instance name, e.g. MSSQL10_50.MSSQLSERVER>
Hope this helps you all fix this problem if you get it. Very poor of MS to release something with a bug as big as this.
Thanks for the feedback, Michael!