Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Detecting SQL Server 2005 Properly

There is a new post in the SQL Server Express blog which indicates the right way to detect SQL Server 2005: Using WMI. The blog post is here:

FAQ: Detecting SQL Server 2005 using WMI

Relying on file paths don't work because file paths can always be altered at install, especially if the database server is SQL Server Express and it's coming packaged with an application. That leaves the registry as the way most people go. However, the post points out that Microsoft reserves the right to change the registry and that they did so between 2000 and 2005. This is true, the registry has changed between these two versions, and it changed between SQL Server 7.0 and 2000 as well. Therefore, WMI is the way to go for detecting SQL Server 2005. This won't help you detect SQL Server 7.0 and 2000 instances, as the SQL WMI Provider doesn't support these older versions, but a tool like SQL Recon does detect these versions using all known available methods (depending on your permissions on the remote system).



Technorati Tags: | | | | |

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.