Post reply

sqlserver.exe and SSMS show incorrect version but reports show differently

  • December 9, 2015 at 4:20 pm

    #322896

    I have recently installed SP3 onto SQL 2008 R2 - in the bootstrap summary file all of the product features discovered show as 10.53.6000.34 as well as a successful install.

    However, SSMS shows a different version (10.50.4000) and the sqlservr.exe file is 10.50.4000 as well.

    I am not sure how this has happened as when I try to reinstall the update this fails because the report indicates that the files are already at the required level.

    Any thoughts please ?

    Thanks

  • December 9, 2015 at 7:59 pm

    #1845090

    I've always relied upon SELECT @@VERSION, because the version to which a client can connect is more important to me. My second choice would be to inspect the errorlog, after SQL Server has been bounced, because that confirms I restarted the correct instance, with that errorlog reporting both the instance name and the build number. As a sanity check, you might want to try one or the other of those. Last I checked, SSMS reports the RTM (original) version, not the service pack build number.

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

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