无法启动Transact-SQL调试器，无法连接到数据库引擎实例 [英] Unable to start the Transact-SQL debugger, could not connect to the database engine instance

问题描述

我一直在尝试在SQl服务器管理工​​作室中运行调试，由于某种原因，调试器刚刚停止工作。

这是我收到的消息：

无法启动Transact-SQL调试器，无法连接到
数据库引擎实例'server-sql'。确保已启用
调试防火墙例外，并且使用的登录名是sysadmin固定服务器角色的成员
。 RPC服务器不可用。

我在此看到了针对相同消息的其他类似答案，建议将登录名添加为sysadmin，但已经设置好了。我还尝试将sysadmin添加到另一个帐户，但这也没有用。

解决方案

最后，我能够启动它通过右键单击并选择以管理员身份运行。

I have been trying to run debugging within SQl server management studio and for some reason the debugger has just stopped working.

This is the message I get:

Unable to start the Transact-SQL debugger, could not connect to the database engine instance 'server-sql'. Make sure you have enabled the debugging firewall exceptions and are using a login that is a member of the sysadmin fixed server role. The RPC server is unavailable.

Before this I get two messages, one requesting firewall permissions and the next says 'usage' with some text that makes little sense.

I have looked at the other similar answers on there for the same message which suggest adding the login as a sysadmin but that is already set. I also tried adding sysadmin to another account but that also didn't work.

解决方案

In the end I was able to start it by right clicking and selecting run as administrator.

这篇关于无法启动Transact-SQL调试器，无法连接到数据库引擎实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！