如何在SQL Server管理工作室中运行查询 [英] How to RUN QUERY IN SQL SERVER MANAGEMENT STUDIO

问题描述

我想知道我们如何在SQL SERVER Management Studio中运行或调试查询.我可以执行查询，但是当我单击运行按钮时，显示的错误与连接和防火墙问题有关.

它表明无法运行T SQL调试.无法连接到本地计算机.

有人可以帮我解决这个问题.

I want to know that how can we run or debug the query in SQL SERVER management studio. Well I can execute the query but when I click on the run button the error which is displayed is regarding the connectivity and firewall issue.

It shows that unable to run T SQL debug. Cannot connect to the computer local.

Could anybody please help me out in resolving this problem.

推荐答案

您必须配置Windows防火墙例外，才能在连接到数据库引擎实例的数据库引擎实例时启用Transact-SQL调试.与数据库引擎查询编辑器在不同的计算机上运行.
来源MSDN
http://msdn.microsoft.com/en-us/library/cc646024.aspx [ ^ ]

You must configure Windows Firewall exceptions to enable Transact-SQL debugging when connected to an instance of the Database Engine that is running on a different computer than the Database Engine Query Editor.
Source MSDN
http://msdn.microsoft.com/en-us/library/cc646024.aspx[^]

我的猜测是您正在连接到远程服务器，并且Management Studio无法在除本地数据库以外的任何内容上进行调试.尝试对本地数据库进行调试.

My guess is that you are connecting to a remote server and that Management Studio is unable to debug on anything but a local database. Try debugging against a local database instead.

请检查您是否具有足够的特权来执行此操作.您的数据库管理员可能已设置了一些限制.

Please check if you have enough previleges to do that.Your database admin might have set some restrictions.

这篇关于如何在SQL Server管理工作室中运行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！