blocks|key|1224392|text|在窗口中单击Start按钮。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1224393|转到All+Programs+->+Microsoft+SQL+Server+2008+->+Configuration+Tools+->+SQL+Server+Configuration+Manager|1224394|在TCP/IP上双击(右键单击SQL+Native+Client+10.0+Configuration+->+Client+Protocols+->+TCP/IP+Properties+)。|1224395|你会找到Default+Port+1433的。|1224396|根据连接的不同，端口号可能有所不同。|1224397|entityMap^0|6|5|0|2|2S|0|1|6|F|1U|2A|A|0|4|H|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|15|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|16|8|@]|D|@]|E|$]]]|O|$]]

Click on <code>Start</code> button in Windows.
Go to <code>All Programs -&gt; Microsoft SQL Server 2008 -&gt; Configuration Tools -&gt; SQL Server Configuration Manager</code>
Click on <code>SQL Native Client 10.0 Configuration -&gt; Client Protocols -&gt; TCP/IP</code>
double click ( Right click select <code>Properties</code> ) on <code>TCP/IP</code>.
You will find <code>Default Port 1433</code>.
Depending on connection, the port number may vary.

blocks|key|1224577|text|尝试此操作(需要访问sys.dm_exec_connections)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1224578|SELECT+DISTINCT+
++++local_tcp_port+
FROM+sys.dm_exec_connections+
WHERE+local_tcp_port+IS+NOT+NULL|code-block|syntax|javascript|1224579|entityMap^0|A|N|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Try this (requires access to <code>sys.dm_exec_connections</code>): 

<pre><code>SELECT DISTINCT 
 local_tcp_port 
FROM sys.dm_exec_connections 
WHERE local_tcp_port IS NOT NULL
</code></pre>

blocks|key|1224349|text|我解决了这个问题，方法是使用SQL+Server配置管理器在SQLEXPRESS2008协议下启用TCP/IP。我重新启动了服务，现在ERRORLOG文件中显示“服务器正在侦听”|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1224350|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 solved the problem by enabling the TCP/IP using the SQL Server Configuration Manager under Protocols for SQLEXPRESS2008, i restarted the service and now the "Server is listening on" shows up in the ERRORLOG file

blocks|key|1439289|text|我在SSMS中使用以下脚本|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1439290|SELECT
+++++s.host_name
++++,c.local_net_address
++++,c.local_tcp_port
++++,s.login_name
++++,s.program_name
++++,c.session_id
++++,c.connect_time
++++,c.net_transport
++++,c.protocol_type
++++,c.encrypt_option
++++,c.client_net_address
++++,c.client_tcp_port
++++,s.client_interface_name
++++,s.host_process_id
++++,c.num_reads+as+num_reads_connection
++++,c.num_writes+as+num_writes_connection
++++,s.cpu_time
++++,s.reads+as+num_reads_sessions
++++,s.logical_reads+as+num_logical_reads_sessions
++++,s.writes+as+num_writes_sessions
++++,c.most_recent_sql_handle
FROM+sys.dm_exec_connections+AS+c
INNER+JOIN+sys.dm_exec_sessions+AS+s
++++ON+c.session_id+=+s.session_id

--filter+port+number
--WHERE+c.local_tcp_port+<>+1433|code-block|syntax|javascript|1439291|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I use the following script in SSMS

<pre><code>SELECT
 s.host_name
 ,c.local_net_address
 ,c.local_tcp_port
 ,s.login_name
 ,s.program_name
 ,c.session_id
 ,c.connect_time
 ,c.net_transport
 ,c.protocol_type
 ,c.encrypt_option
 ,c.client_net_address
 ,c.client_tcp_port
 ,s.client_interface_name
 ,s.host_process_id
 ,c.num_reads as num_reads_connection
 ,c.num_writes as num_writes_connection
 ,s.cpu_time
 ,s.reads as num_reads_sessions
 ,s.logical_reads as num_logical_reads_sessions
 ,s.writes as num_writes_sessions
 ,c.most_recent_sql_handle
FROM sys.dm_exec_connections AS c
INNER JOIN sys.dm_exec_sessions AS s
 ON c.session_id = s.session_id

--filter port number
--WHERE c.local_tcp_port &lt;&gt; 1433
</code></pre>

blocks|key|1224540|text|USE+master
GO
xp_readerrorlog+0,+1,+N'Server+is+listening+on',+'any',+NULL,+NULL,+N'asc'+
GO|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1224541|通过读取SQL+Server错误日志确定SQL+Server数据库引擎的命名实例所使用的端口|unstyled|1224542|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc' 
GO
</code></pre>

[Identify Port used by Named Instance of SQL Server Database Engine by Reading SQL Server Error Logs]

blocks|key|1439434|text|您可以使用以下两个命令：tasklist和netstat+-oan|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1439435|Tasklist.exe类似于taskmgr.exe，但使用的是文本模式。|1439436|使用tasklist.exe或taskmgr.exe可以获得sqlservr.exe的PID|1439437|使用netstat+-oan时，它会显示一个连接PID，您可以对其进行过滤。|1439438|示例：|1439439|C:\>tasklist+%7C+find+/i+"sqlservr.exe"
sqlservr.exe++1184+Services++++0+3.181.800+KB

C:\>netstat+-oan+%7C+find+/i+"1184"
TCP++0.0.0.0:1280++0.0.0.0:0++LISTENING++1184|code-block|syntax|javascript|1439440|在此示例中，SQLServer端口为1280|1439441|摘自：http://www.sysadmit.com/2016/03/mssql-ver-puerto-de-una-instancia.html|1439442|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sysadmit.com/2016/03/mssql-ver-puerto-de-una-instancia.html^0|C|8|L|C|0|0|C|F|B|0|2|C|F|B|U|C|0|2|C|0|0|0|0|3|1Y|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]|$9|17|A|18|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|19|8|@$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1L|8|@$9|1M|A|1N|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|1O|8|@]|D|@]|E|$]]|$1|N|3|O|5|P|7|1P|8|@]|D|@]|E|$Q|R]]|$1|S|3|T|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1R|8|@]|D|@$9|1S|A|1T|1|1U]]|E|$]]|$1|W|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]]|X|$Y|$5|Z|10|11|E|$12|13]]]]

You can use this two commands: <code>tasklist</code> and <code>netstat -oan</code>

<code>Tasklist.exe</code> is like <code>taskmgr.exe</code> but in text mode.

With <code>tasklist.exe</code> or <code>taskmgr.exe</code> you can obtain a PID of <code>sqlservr.exe</code>

With <code>netstat -oan</code>, it shows a connection PID, and you can filter it.

Example:

<pre><code>C:\&gt;tasklist | find /i "sqlservr.exe"
sqlservr.exe 1184 Services 0 3.181.800 KB

C:\&gt;netstat -oan | find /i "1184"
TCP 0.0.0.0:1280 0.0.0.0:0 LISTENING 1184
</code></pre>

In this example, the SQLServer port is 1280

Extracted from: <a href="http://www.sysadmit.com/2016/03/mssql-ver-puerto-de-una-instancia.html" rel="noreferrer">http://www.sysadmit.com/2016/03/mssql-ver-puerto-de-una-instancia.html</a>

blocks|key|1439227|text|This适用于SQL+Server2005-+2012。在应用程序下的错误日志中查找事件id+=+26022。这将显示sql+server的端口号以及允许访问的ip地址。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1439228|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/^0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/" rel="nofollow">This</a> works for SQL Server 2005 - 2012. Look for event id = 26022 in the error log under applications. That will show the port number of sql server as well as what ip addresses are allowed to access.

blocks|key|1439252|text|除了上面列出的内容之外，我还必须启用TCP和UDP端口才能远程连接SQLExpress。因为我的开发机器上有三个不同的实例，所以我同时为TCP和UDP启用了1430-1435。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1439253|entityMap^0|26|9|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In addition to what is listed above, I had to enable both TCP and UDP ports for SQLExpress to connect remotely. Because I have three different instances on my development machine, I enable <code>1430-1435</code> for both TCP and UDP.

I am running MS SQL Server 2008 on my local machine. I know that the default port is 1433 but some how it is not listening at this port. The SQL is an Express edition.

I have already tried the log, SQL Server Management Studio, registry, and extended stored procedure for finding the port. But, I could not find it. Please help me. Thanks.

How to find the port for MS SQL Server 2008?

SQL Server

数据库

服务器

我在本地计算机上运行MS SQL Server 2008。我知道默认端口是1433，但它没有在这个端口上侦听。SQL是Express版本。我已经尝试使用日志、SQL Server Management Studio、注册表和扩展存储过程来查找端口。但是，我找不到它。请帮帮我。谢谢。

问如何找到MS SQL Server 2008的端口？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到MS SQL Server 2008的端口？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到MS SQL Server 2008的端口？
EN