如何找到 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屋!