gangadhar
29th December 2009 07:54 UTC

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

jpderuiter
2nd January 2010 01:14 UTC

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