(imported topic written by SystemAdmin)
I have noticed that the Analysis (ID 54) for MS SQL Server and Client Tools Version Detection in the BES Inventory and License Site does not accurately reflect Service Pack levels for SQL 2005.
We have SQL 2005 SP4 deployed on many servers, but TEM reports them as SP3. After looking at the properties for SQL Server 2005 and Express, anything over version 9.00.3042 is listed as SP3. This is not true because SP4 is version 9.00.5000.00. Here is the site from MS reflecting SQL versioning:
http://support.microsoft.com/kb/321185
Please update this Analysis as soon as possible.