How to find sql server 2005 instances in the LAN?

gangadhar · 29th December 2009, 06:54

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, 00:14

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

29th December 2009, 06:54	#1
gangadhar Junior Member Join Date: Dec 2009 Posts: 1	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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2nd January 2010, 00:14	#2
jpderuiter Major Dude Join Date: Feb 2007 Posts: 672	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