sqlserver2000, 密码被改, sp_password被删除

重做sp_password, 过两天又一样,还是密码被改, sp_password被删除。想到了重装sp4。运行sp4, 脚本出错:replsys.sql 

前提:停止sqlserver服务,退出服务器管理器,并断开网络连接,防止有数据读写。

I had switched the account that SQL Server uses to start and I did this
through the Services MMC. This caused the SQL Server to not listen
properly on LPC(shared memory). Apparently replsys.sql uses this
protocol to communicate with the SQL Server.

1) In the registry, made a backup copy of the LPC key under (备份以下路径)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLserver\SuperSocketNetLib

2) Then delete the LPC key under (删除下面的注册表值)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLserver\SuperSocketNetLib
(Disclaimer: I make no guarantees to anyone who messes with the
registry)

3) Using the Services MMC I set the SQL Server startup account back to
the Local System account and restarted the SQL Server instance.
开启数据库实例

4) Changed the SQL start up account to domain account using the SQL
Enterprise Manager and again restarted that instance of SQL Server.


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值