Error: 17172, severity: 16 sniinitialize () failed with error 0 × 2.

To install SCCM 2012, we upgraded the test database to SQL Server 2008 SP3 + cu4 today, but changed it to a port and found that servcie could not be started.

 

The following error message is displayed in SQL Server errorlog:

 

Error: 17172, severity: 16, state: 1.

Sniinitialize () failed with error 0x2.

SQL Server audit failed to record the server shutdown action.

 

 

I checked it from the Internet because I had one more cluster key value, because my machine was not a cluster. I compared several other machines and found that there was a problem with this server.

 

Solution:

 

1. Check whether the cluster key value exists in the registry. If not, remove the key value.

 

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ mssql10_50.Instance_name\Cluster

 

2. Reboot successful.