如何从 Windows 注册表中找到 sql server 端口号? [英] How can I find sql server port number from windows registry?

问题描述

如何从 windows 中找到 sql server 端口号?有没有通用的方法可以找到 sql server 2000、2005 和 2008 的端口号?

How can I find sql server port number from windows? Is there any generic way to find port number for sql server 2000, 2005 and 2008?

推荐答案

SQL Server 2000

默认实例

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\TCP

命名实例

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP

SQL Server 2005

默认实例和命名实例之间没有区别.根据安装顺序为实例分配一个编号.我们首先需要找到实例的注册表项，它看起来像

There is no distinction between default and named instances. An instance is assigned a number based on the order it was installed. We first need to locate the registry key for the instance, which looks like

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#

'#' 是分配给实例的编号.实例名称存储为此注册表项的默认值.对于默认实例，它是 MSSQLSERVER.

'#' is the number assigned to the instance. The instance name is stored as the default value for this registry key. For a default instance, it is MSSQLSERVER.

一旦找到实例的注册表项，我们就知道 TCP/IP 注册表项是

Once the registry key for the instance is found, we know the TCP/IP registry key is

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\SuperSocketNetLib\TCP\IPAll

SQL Server 2008

默认实例

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\TCP\IPAll

命名实例

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(InstanceName)\MSSQLServer\SuperSocketNetLib\TCP\IPAll

更多信息这里.

这篇关于如何从 Windows 注册表中找到 sql server 端口号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！