Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Have upgraded from 2005 to 2008R2 but still getting security updates for 2005 Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 7:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 3, 2014 7:57 AM
Points: 28, Visits: 107
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
Post #1440788
Posted Thursday, April 18, 2013 2:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 31, 2014 7:48 PM
Points: 119, Visits: 494
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"
Post #1443653
Posted Thursday, April 18, 2013 3:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 1:37 AM
Points: 10, Visits: 65
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
Post #1443710
Posted Thursday, April 18, 2013 8:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 3, 2014 7:57 AM
Points: 28, Visits: 107
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.
Post #1443883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse