After I modify the IP on the DB server , when I restore the modify but my SQLserver service can not start normally and I Cannot open SQLserver configuration manger,you can found some error log in the windows application log.
Symptoms
error log 1: SQL Server could not spawn FRunCM thread. Check the SQLServer error log and the Windows event logs for information about possible relatedproblems. error log 2: Could not start the network library because of aninternal error in the network library. To determine the cause, review the errors immediatelypreceding this one in the error log.TDSSNIClient initialization failed with error 0x2, statuscode 0x1. |
Reference:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/468b8484-2729-4a06-bfc3-efe54507dcb6/sql-express-2005-configuration-manager-cannot-connect-to-wmi-provider?forum=sqltools
Action
1.Copy framedyn.dll" from “C:\WINDOWS\system32\wbem” to“C:\WINDOWS\system32”
2.Add IP address into registry table and it will show as below graphic
TheTCP/IP Properties and set the value to this host IP in it.