如何查找SQL Server运行端口？(How to find SQL Server running port?)

如何查找SQL Server运行端口？(How to find SQL Server running port?)

是我阅读了如何找到MS SQL Server 2008的端口？

没有运气。

telnet 1433

返回连接失败，所以我必须指定其他端口。

我试过使用

netstat -abn

但我看不到sqlservr.exe或类似的东西在这个列表。

为什么这么难找到那个港口？ ：/

Yes I read this How to find the port for MS SQL Server 2008?

no luck.

telnet 1433

returns connection failed, so I must specify other port.

I tried to use

netstat -abn

but I don't see sqlservr.exe or something similar on this list.

Why it so difficult to find that port? :/

最满意答案

尝试这个：

USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

Try this:

USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/