blocks|key|12651|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|12652|端口1433可能已禁用，因此请使用MS+WIndows防火墙启用它。|ordered-list-item|12653|12654|或者只是使用|12655|netsh+firewall+set+portopening+protocol+=+TCP+port+=+1433+name+=+SQLPort+mode+=+ENABLE+scope+=+SUBNET+profile+=+CURRENT|code-block|syntax|javascript|12656|12657|可能未运行MS+SQL+Server+Browser服务。因此，请转到服务并启动它。|12658|12659|或者只在Run菜单下执行|12660|12661|+%25windir%25\system32\services.msc|blockquote|12662|12663|12664|12665|可能在SQL+Server2008/2014配置管理器下禁用了TCP/IP通道。因此，请转到此处并启用所有TCP/IP选项。|12666|12667|​|12668|📷|atomic|offset|length|12669|12670|12671|以防万一在同一位置(SQL+Server2008/2014配置管理器)，请确保您有1433端口。|12672|12673|12674|12675|12676|12677|确保将SQL+server配置为允许远程连接。使用MS+SQL+Management+Studio并右键单击服务器本身的顶层节点。|12678|12679|12680|12681|12682|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/faca2154e27b69f392a0879cfacb9e3e.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/42c99aa1037aa942b2134520f5a6b41c.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/2400632c789afd35c3d3c8c2e7712777.png^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|0|1|2|0|0^^$0|@$1|2|3|-4|4|5|6|20|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|21|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|22|7|@]|8|@]|9|$]]|$1|E|3|F|4|5|6|23|7|@]|8|@]|9|$]]|$1|G|3|H|4|I|6|24|7|@]|8|@]|9|$J|K]]|$1|L|3|-4|4|5|6|25|7|@]|8|@]|9|$]]|$1|M|3|N|4|C|6|26|7|@]|8|@]|9|$]]|$1|O|3|-4|4|5|6|27|7|@]|8|@]|9|$]]|$1|P|3|Q|4|5|6|28|7|@]|8|@]|9|$]]|$1|R|3|-4|4|5|6|29|7|@]|8|@]|9|$]]|$1|S|3|T|4|U|6|2A|7|@]|8|@]|9|$]]|$1|V|3|-4|4|5|6|2B|7|@]|8|@]|9|$]]|$1|W|3|-4|4|5|6|2C|7|@]|8|@]|9|$]]|$1|X|3|-4|4|5|6|2D|7|@]|8|@]|9|$]]|$1|Y|3|Z|4|C|6|2E|7|@]|8|@]|9|$]]|$1|10|3|-4|4|5|6|2F|7|@]|8|@]|9|$]]|$1|11|3|12|4|5|6|2G|7|@]|8|@]|9|$]]|$1|13|3|14|4|15|6|2H|7|@]|8|@$16|2I|17|2J|1|2K]]|9|$]]|$1|18|3|12|4|5|6|2L|7|@]|8|@]|9|$]]|$1|19|3|-4|4|5|6|2M|7|@]|8|@]|9|$]]|$1|1A|3|1B|4|C|6|2N|7|@]|8|@]|9|$]]|$1|1C|3|-4|4|5|6|2O|7|@]|8|@]|9|$]]|$1|1D|3|12|4|5|6|2P|7|@]|8|@]|9|$]]|$1|1E|3|14|4|15|6|2Q|7|@]|8|@$16|2R|17|2S|1|2T]]|9|$]]|$1|1F|3|12|4|5|6|2U|7|@]|8|@]|9|$]]|$1|1G|3|-4|4|5|6|2V|7|@]|8|@]|9|$]]|$1|1H|3|1I|4|C|6|2W|7|@]|8|@]|9|$]]|$1|1J|3|-4|4|5|6|2X|7|@]|8|@]|9|$]]|$1|1K|3|12|4|5|6|2Y|7|@]|8|@]|9|$]]|$1|1L|3|14|4|15|6|2Z|7|@]|8|@$16|30|17|31|1|32]]|9|$]]|$1|1M|3|12|4|5|6|33|7|@]|8|@]|9|$]]|$1|1N|3|-4|4|5|6|34|7|@]|8|@]|9|$]]]|1O|$1P|$4|1Q|1R|1S|9|$1T|1U|1V|-4]]|1W|$4|1Q|1R|1S|9|$1T|1X|1V|-4]]|1Y|$4|1Q|1R|1S|9|$1T|1Z|1V|-4]]]]

<ol>
<li>Probably port 1433 is disabled, so enable it using MS WIndows firewall.</li>
</ol>

or just use

<pre><code>netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT
</code></pre>

<ol start="2">
<li>Probably MS SQL Server Browser Service is not running. So go to Services and start it.</li>
</ol>

or just execute under Run menu

<blockquote>
 %windir%\system32\services.msc
</blockquote>

<ol start="3">
<li>Probably TCP/IP channel is disabled under SQL Server 2008/2014 Configuration Manager. SO go there and enable all TCP/IP options.</li>
</ol>

<a href="https://i.stack.imgur.com/PIFNJ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/PIFNJ.png" alt="enter image description here"></a>

<ol start="4">
<li>Just in case at the same place (SQL Server 2008/2014 Configuration Manager) make sure you have 1433 port.</li>
</ol>

<a href="https://i.stack.imgur.com/BO6Lz.png" rel="noreferrer"><img src="https://i.stack.imgur.com/BO6Lz.png" alt="enter image description here"></a>

<ol start="5">
<li>Make sure that SQL server is configured to allow remote connections. Use MS SQL Management Studio and right click on the top node which server itself.</li>
</ol>

<a href="https://i.stack.imgur.com/qGrMv.png" rel="noreferrer"><img src="https://i.stack.imgur.com/qGrMv.png" alt="enter image description here"></a>

blocks|key|3360487|text|在SQL+Server配置管理器->SQL+Server网络配置->协议中，检查命名管道和tcp/ip是否已启用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3360488|如果这不起作用，那么可能是你的防火墙阻止了它，请尝试这个链接：http://msdn.microsoft.com/en-us/library/cc646023.aspx|offset|length|3360489|这可能也很有用：http://support.microsoft.com/kb/287932|3360490|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/cc646023.aspx|1|http://support.microsoft.com/kb/287932^0|0|V|1H|0|0|8|12|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

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: <a href="http://msdn.microsoft.com/en-us/library/cc646023.aspx">http://msdn.microsoft.com/en-us/library/cc646023.aspx</a>

This may be useful too:
<a href="http://support.microsoft.com/kb/287932">http://support.microsoft.com/kb/287932</a>

blocks|key|3843557|text|如果已在SQL+Server配置管理器中启用命名管道和TCP/IP访问，则需要添加用于UDP端口1434的规则或用于SSMS的规则，以便SSMS客户端可以与SQL+Server+Browser服务通信。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3843558|实际上，我经常看到人们有这个问题，所以我在这里写了一个解释：http://blog.dereenigne.com/microsoft-sql-server-dynamic-ports-windows-firewall-and-you/|3843559|entityMap|0|LINK|mutability|MUTABLE|url|http://blog.dereenigne.com/microsoft-sql-server-dynamic-ports-windows-firewall-and-you/^0|17|3|1C|4|0|U|2F|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

If named pipes and TCP/IP access are already enabled in SQL Server Configuration Manager, then you need to either add a rule for UDP port 1434, or a rule for sqlbrowser.exe so that the SSMS client can talk to the SQL Server Browser service.

I actually see people having this problem surprisingly often so I wrote up an explanation here: <a href="http://blog.dereenigne.com/microsoft-sql-server-dynamic-ports-windows-firewall-and-you/" rel="noreferrer">http://blog.dereenigne.com/microsoft-sql-server-dynamic-ports-windows-firewall-and-you/</a>

blocks|key|3843733|text|如果您正在尝试连接到SQL+Server+Express实例，就像我现在的情况一样…默认情况下，它不使用端口1433。必须在Sql+Server+Configuration+Manager中检查IpAll+=>+TCP+Dynamic+Ports。我的是52848。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3843734|在DbSchema应用程序中输入正确的端口52848+(我正在尝试使用的端口)后，它成功连接。|3843735|检查以下屏幕截图：|3843736|📷|atomic|3843737|​|3843738|这就是我们要做的：|3843739|3843740|默认的SQL+Server+Express安装不启用TCP网络协议，因此，为了能够与SQL+Server+express通信，需要执行以下一些步骤。对于MS+SQL+Server+Express+2017、2016、2014、2012、2008和2005，这些步骤应该类似。|blockquote|3843741|3843742|3843743|3843744|启动SQL+Server配置管理器。它应位于“开始”“->程序”“->+Microsoft+SQL+Server2005+->配置工具”“开始”菜单选项中。|ordered-list-item|3843745|选择“SQL+Server2005网络配置”选项卡。应该有一个用于SQLExpress的协议选项，其中一个协议应该是TCP。|3843746|启用TCP协议(如果未启用)。|3843747|+SQL+Express的默认端口可能不是1433。要找到它正在侦听的端口，请右键单击TCP+IP协议并向下滚动到IP+all标题。应该有一个名为TCP动态端口的部分。这应该列出SQL+Express正在侦听的端口。然后，您可以在通过RazorSQL添加连接配置文件时将此值输入端口字段。|3843748|3843749|请确保在尝试连接之前重新启动SQL+Express。|3843750|原文转载自：https://razorsql.com/docs/support_sqlserver_express.html|3843751|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/8bc64b5195098dd8b4d6dfb05ed9bb98.png|imageAlt|1|LINK|MUTABLE|url|https://razorsql.com/docs/support_sqlserver_express.html^0|A|I|1I|4|1Q|W|2P|Q|0|L|5|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|6|1K|1|0^^$0|@$1|2|3|4|5|6|7|1P|8|@$9|1Q|A|1R|B|C]|$9|1S|A|1T|B|C]|$9|1U|A|1V|B|C]|$9|1W|A|1X|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1Y|8|@$9|1Z|A|20|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|21|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|22|8|@]|D|@$9|23|A|24|1|25]]|E|$]]|$1|M|3|N|5|6|7|26|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|27|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|28|8|@]|D|@]|E|$]]|$1|R|3|S|5|T|7|29|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|2A|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|2B|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|2C|8|@]|D|@]|E|$]]|$1|X|3|Y|5|Z|7|2D|8|@]|D|@]|E|$]]|$1|10|3|11|5|Z|7|2E|8|@]|D|@]|E|$]]|$1|12|3|13|5|Z|7|2F|8|@]|D|@]|E|$]]|$1|14|3|15|5|Z|7|2G|8|@]|D|@]|E|$]]|$1|16|3|-4|5|6|7|2H|8|@]|D|@]|E|$]]|$1|17|3|18|5|6|7|2I|8|@]|D|@]|E|$]]|$1|19|3|1A|5|6|7|2J|8|@]|D|@$9|2K|A|2L|1|2M]]|E|$]]|$1|1B|3|-4|5|6|7|2N|8|@]|D|@]|E|$]]]|1C|$1D|$5|1E|1F|1G|E|$1H|1I|1J|-4]]|1K|$5|1L|1F|1M|E|$1N|1O]]]]

If you're trying to connect to an <code>SQL Server Express</code> instance as is my case right now... it doesn't use port <code>1433</code> by default. One must check the <code>IpAll =&gt; TCP Dynamic Ports</code> in <code>Sql Server Configuration Manager</code>. Mine is 52848.

After entering the correct port <code>52848</code> in DbSchema app (the one I'm trying to use), it connected successfully. 

Check the following screenshot:
<a href="https://i.stack.imgur.com/1Q5JY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Q5JY.png" alt="enter image description here"></a>

This is the way to go:

<blockquote>
 The default SQL Server express installation does not enable TCP
 network protocols, so here are some steps to take to be able to
 communicate with SQL Server Express. These steps should be similar for
 MS SQL Server Express 2017, 2016, 2014, 2012, 2008, and 2005.
</blockquote>

<ol>
<li>Launch the SQL Server Configuration Manager. It should be in the Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools start menu option. </li>
<li>Select the SQL Server 2005 Network Configuration tab. There should be a Protocols for SQLExpress option, and one of the protocols should be TCP IP. </li>
<li>Enable the TCP IP protocol if it is not enabled. </li>
<li>The default port for SQL Express may not be 1433. To find the port it is listening on, right-click on the TCP IP protocol and scroll all the way down to the IP All heading. There should be a section called TCP Dynamic Ports. This should list the port SQL Express is listening on. You can then put this value into the port field when adding the connection profile via RazorSQL. </li>
</ol>

Make sure to restart SQL Express before trying to connect.

Text kindly reproduced from:
<a href="https://razorsql.com/docs/support_sqlserver_express.html" rel="nofollow noreferrer">https://razorsql.com/docs/support_sqlserver_express.html</a>

blocks|key|3843662|text|我的服务器中有多个NIC。当我转到SQL+Server+Network+Configuration+->+TCP/IP并右键单击属性时，有一个NIC列表，底部是我的SQLEXPRESS的开放端口。不是1433……我不知道是否有违约，但我的是在49,000美元。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3843663|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had multiple NICs in my server. When I went to SQL Server Network Configuration -> TCP/IP and right clicked for properties there was a list of the NICs and at the bottom was the open port for my SQLEXPRESS. It was not 1433..... I do not know if there is a default but mine was in the 49,000 s.

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.......

Firewall Port 1433 not opening

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我使用MS server 2008和MSSQL 2008-R2作为数据库服务器。1.为tcp端口1433创建入站和出站规则。2.在sqlserver配置管理器中，为IP地址设置了all，为POrt设置了no属性。3.设置远程连接的SqlServer实例。但它仍然不起作用。另外，当我在本地计算机上检查端口1433的tcp时，它显示为关闭。提前感谢......

问防火墙端口1433未打开
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问防火墙端口1433未打开EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问防火墙端口1433未打开
EN