调试SQL Server 2005存储过程

I am using VS 2008 and trying to step into a stored procedure on a SQL Server 2005 database. I bring up Server Explorer, double-click on the procedure. It comes up in the text window. I set a break point in it, right click and select "Step into stored procedure". It comes back with "canceled by user". MSVSCOM.exe is running on the SQL Server host and I can connect to remote processes on SQL Server host. Can you tell me what I am doing wrong?

我正在使用VS 2008并试图进入SQL Server 2005数据库的存储过程。我打开服务器资源管理器,双击该过程。它出现在文本窗口中。我在其中设置了一个断点,右键单击并选择“Step into stored procedure”。它返回“用户取消”。 MSVSCOM.exe正在SQL Server主机上运行,我可以连接到SQL Server主机上的远程进程。你能告诉我我做错了什么吗?

3 个解决方案

#1

I guess you have two different version of remote monitor running on each of these machines.

我猜你在这些机器上运行了两个不同版本的远程监控器。

"This error commonly shows when mismatching versions of msvsmon.exe (Remote Debugging Monitor) is used. They have to be of the same version in order to do remote CLR debugging. The locations: 2008 -> C:\Program Files\Microsoft Visual Studio 9\Common7\IDE\Remote Debugger\x86\msvsmon.exe, version 9.0.2 2005 -> C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\Remote Debugger\x86\msvsmon.exe, version 8.0.5"

“当使用不匹配的msvsmon.exe(远程调试监视器)版本时,通常会显示此错误。它们必须是相同版本才能进行远程CLR调试。位置:2008 - > C:\ Program Files \ Microsoft Visual Studio 9 \ Common7 \ IDE \ Remote Debugger \ x86 \ msvsmon.exe,版本9.0.2 2005 - > C:\ Program Files \ Microsoft Visual Studio 8 \ Common7 \ IDE \ Remote Debugger \ x86 \ msvsmon.exe,版本8.0。 5"

This is a nice article on setting up remote debugging that should resolve your issue. Please post back if you cannot resolve it

这是一篇关于设置远程调试的好文章,可以解决您的问题。如果您无法解决,请回复

http://msdn.microsoft.com/en-us/library/bt727f1t.aspx

#2

Finally resolved this issue by running Visual Studio, the Server Explorer connection and the Remote Debugging Service all with the same credentials.

最后通过使用相同的凭据运行Visual Studio,Server Explorer连接和远程调试服务来解决此问题。

#3

I was able to resolve this issue by setting the "Log on as" account for SQL Server (MSSQLSERVER) to the server's Administrator account. For reference, my complete setup is as follows:

我能够通过将SQL Server(MSSQLSERVER)的“登录身份”帐户设置为服务器的管理员帐户来解决此问题。作为参考,我的完整设置如下:

Client: Windows XP with VS Studio 2008 (9.0.30729.1), Server: Windows Server 2003 with SQL Server 2005 (9.0.4035)

客户端:带有VS Studio 2008的Windows XP(9.0.30729.1),服务器:带有SQL Server 2005的Windows Server 2003(9.0.4035)
Both computers in the same workgroup

两台计算机位于同一工作组中
Administrator account on both machines enabled and set to same password.

两台计算机上的管理员帐户已启用并设置为相同的密码
MSSQLSERVER and MSVCMON (running as a Service) run in the context of the Administrator account.

MSSQLSERVER和MSVCMON(作为服务运行)在Administrator帐户的上下文中运行。
Visual Studio 2008 run in the context of my account (member of Administrators group) on the client machine. The same account was created on the server (member of Administrators group) and the password is the same on both.

Visual Studio 2008在客户端计算机上的帐户(Administrators组成员)的上下文中运行。在服务器(Administrators组成员)上创建了相同的帐户,两者的密码相同。

#1