Post reply

Retrieve all Sql server AND their editions on network

  • April 9, 2010 at 8:33 am

    #217724

    I need a way to get a list of all SQL servers on our network.

    We have a mixture of 2000, 2005, and 2008 versions.

    I have been able to do this in a couple of ways using either the SQLBrowserConnect method and the System.Data.Sql.SqlDataSourceEnumerator.Instance method.

    Both of those work great for retrieving the Server Name. My problem is that I also would like to retrieve the Edition. The reason I want the Edition is that I would like to ignore all Express editions in the network.

    Possibly there is another solution??

    Please help!

    thanks!

  • April 9, 2010 at 8:58 am

    #1149191

    get a copy of the free program SQLRecon from specialopssecurity.com[/url];

    it is the most full featured pprogram I've found for discovering all the SQL servers on a network;

    the documentation says it uses eight different methods to discover SQL server instances.

    joshua.burwell (4/9/2010)

    I need a way to get a list of all SQL servers on our network.

    We have a mixture of 2000, 2005, and 2008 versions.

    I have been able to do this in a couple of ways using either the SQLBrowserConnect method and the System.Data.Sql.SqlDataSourceEnumerator.Instance method.

    Both of those work great for retrieving the Server Name. My problem is that I also would like to retrieve the Edition. The reason I want the Edition is that I would like to ignore all Express editions in the network.

    Possibly there is another solution??

    Please help!

    thanks!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 9, 2010 at 9:12 am

    #1149205

    Thank you but that doesn't get me much more than what I'm already getting. Plus it's a manual process. I'm looking for something I can automate within .net.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply