Sql 2014注册表项 [英] Sql 2014 registry entry

问题描述

我想检查当前系统是否有SQL 2014（正是这个版本的SQL）。因此，我计划检查注册表端以确保系统已安装SQL 2014.我需要确切的注册表路径来检查SQL 2014.卸载SQL 2014后需要删除相同的注册表路径。



请提供我需要检查的注册表路径。



提前致谢!!!!



我尝试了什么：



我已经验证了以下路径，但我不确定这个的正确与否。

 HKEY_LOCAL_MACHINE\SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server\\120\\SQLServer2014 \\ CurrentVersion \版本

解决方案

检查： SQL Serve的默认实例和命名实例的文件位置r - SQL Server | Microsoft Docs [ ^ ]

Sql Server 2014代码是120，所以注册表项是：

 HKLM \Software \ Mysoftoft \ Microsoft SQL Server \ 120 

Quote：

单台计算机上所有实例使用的公共文件都安装在文件夹< drive>中：\ Program Files \ Microsoft SQL Server \\\
nn \。 < drive>

[首发帖子]

我不知道哪个注册表项负责存储此类信息，但您可以枚举LAN中的所有MS SQL服务器实例（即使在本地计算机上）。请参阅：如何在网络中枚举SQL Server实例 [ ^ ]



注意：请从MSDN上阅读有关该技巧中使用的方法的其他信息：SqlDataSourceEnumerator.GetDataSources方法（System.Data.Sql）| Microsoft Docs [ ^ ]





我还建议阅读： https：/ /blog.sqlauthority.com/2016/11/12/sql-server-get-list-sql-server-instances-installed-machine/ [ ^ ]

戴夫recommeds使用PowerShell命令：

<预郎= 的Perl> GET-ItemProperty 'HKLM：\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL'

或

 Get-Service | ？{ 

_ .DisplayName-like SQL Server（*}

I would like check the current system has SQL 2014 (Exactly this version of SQL). So I plan to check the registry side to make sure the system has installed SQL 2014. I would need the exact registry path to check SQL 2014. The same registry path need to remove after uninstalling the SQL 2014.

Please provide the registry path which I need to check.

Thanks in advance!!!!

What I have tried:

I have verified the below path but I am not sure this one is correct or not.

HKEY_LOCAL_MACHINE\SOFTWARE\\Wow6432Node\\Microsoft\\Microsoft SQL Server\\120\\SQLServer2014\\CurrentVersion\Version

解决方案

[EDIT#3]

Check this: File Locations for Default and Named Instances of SQL Server - SQL Server | Microsoft Docs[^]
Sql Server 2014 code is 120, so registry key is:

HKLM\Software\Microsoft\MicrosoftSQL Server\120

Quote:

Common files used by all instances on a single computer are installed in the folder <drive>:\Program Files\Microsoft SQL Server\nnn\. <drive>

[Initial post]
I have no idea which registry entry is responsible to store such of information, but you can enumerate all instances of MS SQL server in LAN (even on local computer). See: How to enum SQL Server instances in network[^]

Note: please, read additional information about method used in that trick from MSDN: SqlDataSourceEnumerator.GetDataSources Method (System.Data.Sql) | Microsoft Docs[^]

[EDIT#2]
I also recommend to read this: https://blog.sqlauthority.com/2016/11/12/sql-server-get-list-sql-server-instances-installed-machine/[^]
Dave recommeds to use PowerShell command:

Get-ItemProperty ‘HKLM:\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL’

or

Get-Service | ?{ 

_.DisplayName -like "SQL Server (*" }

这篇关于Sql 2014注册表项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！