无法与重定向器建立连接.确保"SQL浏览器"服务正在运行 [英] a connection cannot be made to redirector. Ensure that 'sql browser' service is running

问题描述

所以我正在尝试使用此sql server 2012，由于此错误，我无法打开任何sis软件包

So Im trying this sql server 2012, and I cant open any ssis package due to this error

无法与重定向器建立连接.确保"SQL浏览器"服务正在运行

a connection cannot be made to redirector. Ensure that 'sql browser' service is running

我的Sql Browser肯定正在运行，我尝试在本地服务，本地系统和网络下更改它，但仍没有任何结果，将不胜感激

my Sql Browser is running for sure, I tried changing it under local service, local system and network, still no result yet, any help would be appreciated

谢谢

推荐答案

此错误似乎仅与命名实例有关.原因是SQL客户端无法解析实例，因为SQL客户端无法访问SQL Browser服务. SQL Browser服务解析实例名称

This error seems to related only to named instances. The reason is SQL client is not able to resolve instance because SQL client has no access SQL Browser Service. SQL Browser Service resolves instance name

1. 确保SQL浏览器服务正在运行
2. 确保未阻止PC上运行SQL浏览器服务的端口(默认端口2382)

或者，您可以通过在客户端连接属性中使用"Server:Port"而不是"Server \ instance name"来绕过SQL Browser服务

Alternatively, you can bypass SQL Browser Service, by mentioning "Server:Port" instead of "Server\instance name", in the client connection properties

这篇关于无法与重定向器建立连接.确保"SQL浏览器"服务正在运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！