Error: 17172, Severity: 16 SNIInitialize () failedwitherror

To install SCCM2012, we upgraded the test database to SQLServer2008SP3CU4 today, but changed it to a port and found that Servcie could not be started. The following Error message is displayed in SQLServererrorlog: Error: 17172, Severity: 16, State: 1. SNIInitialize () failedwitherror0x2. SQLServerAudit

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

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.