如何找到 MS SQL Server 2008 的端口? [英] How to find the port for MS SQL Server 2008?

问题描述

我在本地机器上运行 MS SQL Server 2008.我知道默认端口是 1433，但有些原因是它不在此端口上侦听.SQL 是 Express 版本.

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.

我已经尝试使用日志、SQL Server Management Studio、注册表和扩展存储过程来查找端口.但是，我找不到它.请帮我.谢谢.

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.

推荐答案

在 Windows 中点击 Start 按钮.

Click on Start button in Windows.

转到<代码>所有程序->Microsoft SQL Server 2008 ->配置工具 ->SQL Server 配置管理器

点击SQL Native Client 10.0配置->客户端协议 ->TCP/IP双击(右键单击选择 Properties )TCP/IP.

Click on SQL Native Client 10.0 Configuration -> Client Protocols -> TCP/IP double click ( Right click select Properties ) on TCP/IP.

您会发现默认端口 1433.

根据连接情况，端口号可能会有所不同.

Depending on connection, the port number may vary.

这篇关于如何找到 MS SQL Server 2008 的端口?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！