无法调试SQL2000中的存储过程

最新推荐文章于 2024-06-03 10:44:02 发布

最新推荐文章于 2024-06-03 10:44:02 发布 · 149 阅读

本文解决SQL2000中调试存储过程时遇到的问题，包括系统文件缺失和SQLDebugger账户被禁用的情况，并提供了解决方案。

在调试SQL2000中的存储过程时报错，错误信息为如下：

无法启动sql调试会话，确保本机上注册了sqldbreg.exe和proxy/stub DLL sqldbreg.dll

出现这个问题的原因有几种：

1.调试需要的系统文件丢失。如果是这种情况可以复制需要的系统文件并注册，或者重新安装SQL Server。

2.禁止了SQLDebugger 账户造成的，这种情况比较常见。如果你也碰到这样的问题，可以检查一下SQLDebugger用户帐户是否启用。

注调试存储过程需要的系统文件如下：

This component Is installed on..
SQLLE.DLL the Client.
SQLDBG.DLL the Client and Server.
MSSDI98.DLL the Server. This must be present in the \binn directory of every SQL server instance. This needs to be the version of MSSDI98.DLL installed by Visual Studio. QueryAnalyzer installs a version of MSSDI98.DLL to this same location, but the QueryAnalyzer version is not compatible with Visual Studio SQL debugging.
SQLDBREG2.EXE the Client.

This component	Is installed on..
SQLLE.DLL	the Client.
SQLDBG.DLL	the Client and Server.
MSSDI98.DLL	the Server. This must be present in the \binn directory of every SQL server instance. This needs to be the version of MSSDI98.DLL installed by Visual Studio. QueryAnalyzer installs a version of MSSDI98.DLL to this same location, but the QueryAnalyzer version is not compatible with Visual Studio SQL debugging.
SQLDBREG2.EXE	the Client.