Post reply

Have upgraded from 2005 to 2008R2 but still getting security updates for 2005

  • April 10, 2013 at 7:06 am

    #273315

    Hi there,

    We've recently upgraded a 2005 SQL cluster (active / active) to 2008 R2. There still seems to be SQL 2005 client tools including SSMS but the version in the registry setting and on the SQL instances is 10.50.4000.

    I just recently checked for security updates for the server and I was troubled to see that one of them coming up is "Security Update for SQL Server 2005 Service Pack 4 Failover Clustering".

    Has anyone else experienced this or why this is happening and how to resolve this?

    Thanks,

    Mike

  • April 18, 2013 at 2:07 am

    #1607571

    Hope this helps you with some understanding..

    http://msdn.microsoft.com/en-us/library/ms191295.aspx

    http://www.sqlservercentral.com/blogs/pearlknows/2010/12/13/upgrading-to-sql-server-2008-a-comprehensive-checklist/

    Cheers,
    - Win
    "Dont Judge a Book by its Cover"

  • April 18, 2013 at 3:50 am

    #1607611

    Was this an in place or side by side upgrade? In Place upgrades are somewhat tedious and I have done 100s of SQL server migrations\upgrades with all side by side due to the most safe method as per my experience, reliability, easiness etc that it offers overall.

    I think you should check on server Control Panel --> ALL Programs to see if any SQL 2005 component still there? Also, you can check registry files to see if entries are there for SQL 2005. Also, you can check services.msc, config manager etc to confirm various things for this.

    Thanks,

    Vikas

  • April 18, 2013 at 8:01 am

    #1607772

    Thank you for the replies.

    There are still SQL 2005 client components on the server even though the version of the SQL instances is 2008 R2. I suspect that this is why windows thinks that the hotfix needs to be applied.

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

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