防火墙端口1433未打开 [英] Firewall Port 1433 not opening

问题描述

我使用MS Server 2008-MSSQL 2008-R2作为数据库服务器。

每次一些工作，我必须通过远程连接登录服务器。要配置
SQL Server远程连接，请按照以下步骤操作。

1.created用于tcp端口1433的入站和出站规则。 p>

2.在sqlserver配置管理器中，所有设置为IP地址和POrt没有属性。

用于远程连接的SqlServer实例。

但它仍然不工作。

此外，当我在本地计算机上查看tcp的1433端口时，它显示已关闭。

......

解决方案

在SQL Server配置管理器 - > SQL Server网络配置 - >协议中，
$ b

如果这不工作，那么可能是您的防火墙阻止它，请尝试此链接：http://msdn.microsoft.com/en-us/library/cc646023.aspx

这也可能有用：
http://support.microsoft.com/kb/287932

I am using MS Server 2008 with MSSQL 2008-R2 as database server.

Each time for some work i have to login to server via Remote connection.I tried to configure the SQL Server remote connection on, followed the following steps....

1.Created Inbound and outbound rules for tcp port 1433.

2.In sqlserver configuration manager ,all is set for IP address and POrt no properties.

3.Set the SqlServer instance for remote connections.

But still its not working.

Also when i checked port 1433 for tcp on local computer it is shown closed.

thanks in advance.......

解决方案

In the SQL Server Configuration Manager->SQL Server Network Configuration->Protocols, check that named pipes and tcp/ip are enabled.

If that doesn't work then it may be your firewall blocking it, try this link: http://msdn.microsoft.com/en-us/library/cc646023.aspx

This may be useful too: http://support.microsoft.com/kb/287932

这篇关于防火墙端口1433未打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！