sqlserver2000, 密码被改， sp_password被删除_password过程一下被删除-优快云博客

本文详细介绍了如何解决SQL Server使用Services MMC切换账号导致的启动问题，包括通过注册表备份、删除相关键值、设置SQL Server启动账号回退到本地系统账户并重启实例等步骤。同时，提供了通过Services MMC重新设置SQL Server启动账号为域账户的方法，确保SQL Server正常运行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

重做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.