locked
SQL Server Management Pack DB Engine Reports strange/wrong version RRS feed

  • Question

  • Hi All,

    I just found an interresting issue. Using the latest management packs for SQL Server (6.3.173.1) the discovery lists our SQL Servers, with an incorrect version. For example an instance with SQL 2008 Service Pack 3 reports version 10.3.5770.0, while the actual version is 10.0.5770.0.

    A SQL Server 2008 R2 Service Pack 2 reports version 10.52.4000.0, while the actual version 10.50.4000.0.

    It seems like the version pack version gets added to the major product version.

    This is the case for the DB Engine, SSAS and SSRS

    Does anyone have some more information on this? Or why this is done?

    Friday, September 21, 2012 11:36 AM

Answers

  • Hi

    I think this is a SQL Server issue when pulling back server versions using WMI. A connect item has been logged for it - more details here:

    http://joedantoni.wordpress.com/2012/04/02/what-version-of-sql-server-am-i-running/

    This links off to the connect item which I have copied and pasted below:

    The following WMI returns: PropertyStrValue : 10.51.2500.0
    $computer = "LocalHost"
    $namespace = "root\Microsoft\SqlServer\ComputerManagement10"
    Get-WmiObject -class SqlServiceAdvancedProperty -computername $computer -namespace $namespace | Where-Object -FilterScript {$_.PropertyName -eq "VERSION"}

    SELECT SERVERPROPERTY('productversion') returns: 10.50.2500.0

    You might want to check to see if this is what you are seeing.

    I can confirm that I can see the exact same issue on a random selection of my SQL Servers.

    Cheers

    Graham


    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    • Marked as answer by MVerbaas Monday, September 24, 2012 12:16 PM
    Saturday, September 22, 2012 12:58 AM

All replies

  • Hi

    I think this is a SQL Server issue when pulling back server versions using WMI. A connect item has been logged for it - more details here:

    http://joedantoni.wordpress.com/2012/04/02/what-version-of-sql-server-am-i-running/

    This links off to the connect item which I have copied and pasted below:

    The following WMI returns: PropertyStrValue : 10.51.2500.0
    $computer = "LocalHost"
    $namespace = "root\Microsoft\SqlServer\ComputerManagement10"
    Get-WmiObject -class SqlServiceAdvancedProperty -computername $computer -namespace $namespace | Where-Object -FilterScript {$_.PropertyName -eq "VERSION"}

    SELECT SERVERPROPERTY('productversion') returns: 10.50.2500.0

    You might want to check to see if this is what you are seeing.

    I can confirm that I can see the exact same issue on a random selection of my SQL Servers.

    Cheers

    Graham


    Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
    View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

    • Marked as answer by MVerbaas Monday, September 24, 2012 12:16 PM
    Saturday, September 22, 2012 12:58 AM
  • Hi Graham,

    You're right on the money with this, WMI reports the wrong (other) version.

    I voted on the connect Item, hopefully some more votes will get this fixed/clearer.

    Regards,

    Mark

    Monday, September 24, 2012 12:16 PM