none
Can MAP discovery SQL 6.5 and 7? Also Clustered SQL servers? RRS feed

Answers

  • We did some limited testing on detecting SQL 7, and it appeared to work when the latest service packs were installed on SQL 7.  However, we didn't extensively test this.   No testing was done for SQL 6.5

    If you're desperate, this query run against a MAP database will give you a list of all computers that are running the SQL Server service, but won't do much to tell you what version it is:

     

    SELECT dbo.GetDeviceNameForDisplay(si.device_number),

    si

    .name

    FROM

     

    services si

     

    INNER JOIN unique_devices ud

     

    ON si.device_number = ud.device_number

     

    WHERE si.name != 'MSSQL$MICROSOFT##SSEE' AND

     

     

    (

    si

    .name like 'MSSQL$%'

     

    OR si.name like 'MSSQLSERVER')


     if that query doesn't work exactly right, take a look at a machine with SQL 6.5 / 7.0 on it and see what the service name is, then adjust this query to add those varieties...

    Saturday, November 28, 2009 12:14 AM

All replies

  • We did some limited testing on detecting SQL 7, and it appeared to work when the latest service packs were installed on SQL 7.  However, we didn't extensively test this.   No testing was done for SQL 6.5

    If you're desperate, this query run against a MAP database will give you a list of all computers that are running the SQL Server service, but won't do much to tell you what version it is:

     

    SELECT dbo.GetDeviceNameForDisplay(si.device_number),

    si

    .name

    FROM

     

    services si

     

    INNER JOIN unique_devices ud

     

    ON si.device_number = ud.device_number

     

    WHERE si.name != 'MSSQL$MICROSOFT##SSEE' AND

     

     

    (

    si

    .name like 'MSSQL$%'

     

    OR si.name like 'MSSQLSERVER')


     if that query doesn't work exactly right, take a look at a machine with SQL 6.5 / 7.0 on it and see what the service name is, then adjust this query to add those varieties...

    Saturday, November 28, 2009 12:14 AM
  • Sorry, the 2nd part f your question was about clustering...  MAP will find all the servers involved in a cluster and will usually also find the virtual computer name created for the cluster if you do an IP address range scan or AD scan.  However, it doesn't do anything to show you how the machines in the cluster are related to each other (it doesn't show that a particular set of 4 machines are part of the same cluster, nor does it distinguish the virutal computer name from the underlying hardware of the machine that the service group is currently running on).
    Saturday, November 28, 2009 12:17 AM