blocks|key|361991|text|1433|type|unstyled|depth|inlineStyleRanges|entityRanges|data|361992|默认端口尚未更改|361993|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

1433

the default port hasn't changed yet

blocks|key|3365654|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3365655|默认的SQL+Server端口是1433，但前提是这是默认安装。1434.|ordered-list-item|3365656|Reporting服务是一项|3365657|服务，所以它的端口是80，如果它的SSL服务是2382，那么它就是443，但前提是这是默认安装。命名实例获取随机端口号。|3365658|entityMap^0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|J|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|K|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|L|7|@]|8|@]|9|$]]|$1|F|3|G|4|5|6|M|7|@]|8|@]|9|$]]|$1|H|3|-4|4|5|6|N|7|@]|8|@]|9|$]]]|I|$]]

<ol>
<li>The default SQL Server port is 1433 but only if it's a default install. Named instances get a random port number.</li>
<li>The browser service runs on port UDP 1434.</li>
<li>Reporting services is a web service - so it's port 80, or 443 if it's SSL enabled.</li>
<li>Analysis services is 2382 but only if it's a default install. Named instances get a random port number.</li>
</ol>

blocks|key|3365667|text|默认的未命名实例始终为TCP获取端口1433。SQL+Browser服务使用UDP端口1434来定位命名实例。在SQL+Server2000中，要启动的第一个实例承担了此角色。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3365668|默认情况下，非默认实例会获得自己的动态分配端口。如有必要，例如配置防火墙，您可以显式设置它们。如果您不想启用或允许访问SQL+Browser，则必须在连接字符串中包含实例的端口号，或者在每台客户端计算机上使用cliconfg+(SQL+Server客户端网络实用程序)中的“别名”选项卡进行设置。|offset|length|style|CODE|3365669|有关更多信息，请参阅MSDN上的SQL+Server+Browser+Service。|3365670|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms181087(SQL.90).aspx^0|0|2W|8|0|G|Q|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

The default, unnamed instance always gets port 1433 for TCP. UDP port 1434 is used by the SQL Browser service to allow named instances to be located. In SQL Server 2000 the first instance to be started took this role.

Non-default instances get their own dynamically-allocated port, by default. If necessary, for example to configure a firewall, you can set them explicitly. If you don't want to enable or allow access to SQL Browser, you have to either include the instance's port number in the connection string, or set it up with the Alias tab in <code>cliconfg</code> (SQL Server Client Network Utility) on each client machine.

For more information see <a href="http://msdn.microsoft.com/en-us/library/ms181087(SQL.90).aspx" rel="noreferrer">SQL Server Browser Service</a> on MSDN.

blocks|key|3152796|text|您可以使用SQL配置管理器设置单个IP地址是否使用动态端口(值0=是，使用动态端口)，并设置用于每个IP的TCP端口。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3152797|但要小心:我建议首先规划出您的实例、IP和端口，并在开始随意进行更改之前进行规划，以确保实例或IP不会彼此重叠。|3152798|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You can use SQL Configuration Manager to set individual IP addresses to use dynamic ports or not (value of 0 = yes, use dynamic port), and to set the TCP port used for each IP.

But be careful: I recommend first mapping out your instances, IPs, and ports, and planning such that no instances or IPs step on each other before starting to make changes willy-nilly.

blocks|key|362607|text|如果您有访问服务器的权限，则可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|362608|select+local_tcp_port+from+sys.dm_exec_connections+where+local_tcp_port+is+not+null|code-block|syntax|javascript|362609|有关详细信息，请参阅port+number+of+SQL+Server|offset|length|362610|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/1281150/port-number-of-sql-server/5035779#5035779^0|0|0|A|P|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

If you have access to the server then you can use 

<pre><code>select local_tcp_port from sys.dm_exec_connections where local_tcp_port is not null
</code></pre>

For full details see <a href="https://stackoverflow.com/questions/1281150/port-number-of-sql-server/5035779#5035779">port number of SQL Server</a>

blocks|key|3365708|text|我们可以通过三种不同的方法来识别SQL+Server实例所使用的端口。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3365709|3365710|使用SQL+Server配置管理器读取SQL+Server错误日志|ordered-list-item|3365711|使用|3365712|使用Windows应用程序事件查看器|3365713|3365714|使用master|3365715|去|3365716|xp_readerrorlog+0，1，N‘服务器正在侦听’，'any'，NULL，NULL，N‘’asc‘|3365717|GO|3365718|3365719|使用SQL+Server配置管理器标识SQL+Server数据库引擎使用的端口|blockquote|3365720|3365721|3365722|3365723|在SQL+Server配置管理器中，单击开始->程序->+Microsoft+SQL+Server+2008+->+Configuration+Tools+->+SQL+Server+Configuration+Manager+|3365724|，展开SQL+Server网络配置，然后在左侧面板上选择协议。要标识SQL+Server实例使用的TCP/IP端口，请右键单击TCP/IP，然后从下拉列表中选择属性，如下所示。|3365725|3365726|如需更多帮助|3365727|http://sqlnetcode.blogspot.com/2011/11/sql-server-identify-tcp-ip-port-being.html|offset|length|3365728|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|29|0|0^^$0|@$1|2|3|4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1J|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|1K|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|1L|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1N|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1O|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1P|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|T|3|U|5|V|7|1S|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|Z|3|10|5|E|7|1W|8|@]|9|@]|A|$]]|$1|11|3|12|5|E|7|1X|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|20|8|@]|9|@$18|21|19|22|1|23]]|A|$]]|$1|1A|3|-4|5|6|7|24|8|@]|9|@]|A|$]]]|1B|$1C|$5|1D|1E|1F|A|$1G|17]]]]

We can take a look at three different ways you can identify the port used by an instance of SQL Server.

<ol>
<li>Reading SQL Server Error Logs</li>
<li>Using SQL Server Configuration Manager</li>
<li>Using Windows Application Event Viewer

USE master 
GO

xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc' 
GO</li>
</ol>

<blockquote>
 Identify Port used by SQL Server Database Engine Using SQL Server
 Configuration Manager
 
 <ol>
 <li>Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager</li>
 <li>In SQL Server Configuration Manager, expand SQL Server Network Configuration and then select Protocols for on the
 left panel. To identify the TCP/IP Port used by the SQL Server
 Instance, right click onTCP/IP and select Properties from the drop
 down as shown below.</li>
 </ol>
</blockquote>

For More Help 
<a href="http://sqlnetcode.blogspot.com/2011/11/sql-server-identify-tcp-ip-port-being.html" rel="nofollow">http://sqlnetcode.blogspot.com/2011/11/sql-server-identify-tcp-ip-port-being.html</a>

blocks|key|3152898|text|SQL+Server默认端口为1434。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3152899|要允许远程访问，我必须在防火墙上释放这些端口：|3152900|Protocol++%7C+++Port
---------------------
UDP+++++++%7C+++1050
TCP+++++++%7C+++1050
TCP+++++++%7C+++1433
UDP+++++++%7C+++1434|code-block|syntax|javascript|3152901|entityMap^0|F|4|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

SQL Server default port is 1434.

To allow remote access I had to release those ports on my firewall:

<pre><code>Protocol | Port
---------------------
UDP | 1050
TCP | 1050
TCP | 1433
UDP | 1434
</code></pre>

I need to know the default port settings for the following services

<ol>
<li>SQL Server</li>
<li>SQL Browser</li>
<li>SQL Reporting services</li>
<li>SQL Analysis services</li>
</ol>

I neeed to know the port settings for these services for different versions of SQL Server (2000,2005,2008)

Also let me know whether the default port setting will change based on sql server versions

Thanks in advance.

Default port for SQL Server

SQL Server

数据库

服务器

防火墙

Windows

我需要知道以下服务的默认端口设置SQL ServerSQL BrowserSQL报表服务SQL分析服务<代码>G29</代码>我需要知道不同版本的SQL Server (2000、2005、2008)的这些服务的端口设置另外，请让我知道默认端口设置是否会根据sql server的版本而改变。提前谢谢。

问SQL Server的默认端口
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server的默认端口EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server的默认端口
EN