How to find sql server 2005 instances in the LAN?

2 posts

gangadharDecember 29, 2009 at 5:54 AM#

How to find sql server 2005 instances in the LAN?

Hi,

Is it possible to find the installed Sql Server 2005 instances in the LAN and local machine using NSIS scripting? Can we also validate if the sql server instances are SQL Server 2005 editions?

Please let me know about it.

Thanks,
Gdhar

jpderuiterJanuary 1, 2010 at 11:14 PM#

You can query any SQL database with the MSSQL OLEDB plugin:

http://nsis.sourceforge.net/MSSQL_OLEDB_plug-in

See the MS SQL documentation how to query for the database version