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

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

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?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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