TDSSNIClient initialization failed with error 0x2, statuscode 0x1.

在尝试修改数据库服务器的IP并恢复更改后,若MySQL服务无法正常启动且无法打开SQL Server配置管理器,可能会出现登录Windows应用程序日志中的错误。本文详细介绍了两个错误日志的内容以及相应的解决方案:SQL Server无法启动FRunCM线程,网络库启动失败。通过复制关键文件到指定目录以及修改注册表中IP地址设置,可以解决这些问题。

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.



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值