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

From the Real World: SQL Server 2000 SP4 Installation Failure Expand / Collapse
Author
Message
Posted Wednesday, March 4, 2009 12:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 6:06 AM
Points: 33, Visits: 177
Comments posted to this topic are about the item From the Real World: SQL Server 2000 SP4 Installation Failure
Post #667891
Posted Wednesday, March 4, 2009 2:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 6, 2014 3:56 AM
Points: 21, Visits: 118
Hi

Thanks for your walkthrough Praveen.
After reading I have this one question :
Is it correct to summarize the article down to the claim that it was caused by someone "changing the SQL service account from services console instead of Enterprise manager". If that hadn't been done - the SP4 would have been applied fine ?

- But you listed the troubleshooting very educationally and I bet it will save other the time and hazzle :)



Post #667961
Posted Wednesday, March 4, 2009 4:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 2:32 AM
Points: 65, Visits: 354
Thanks Praveen.I was too planning to upgraded one of our critcal server to sp4 . This would help me if i face similar issues.
Post #668006
Posted Wednesday, March 4, 2009 8:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 4:41 PM
Points: 4, Visits: 30
Excellent article and explanation of this issue Praveen! We found out quickly how important it was to use EM vs. Svcs console to change the service account when we were doing domain migrations on our clusters. Thanks for sharing.
Mike K
Post #668296
Posted Wednesday, March 4, 2009 9:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 6, 2010 1:30 PM
Points: 34, Visits: 82
well done. I have always distrusted 2000 clusters because MS was so picky about them. I am now using 2005 clusters and they are unproblematic except for their exclusive demand for kerberos in the domain. Again, well done.
Post #668431
Posted Wednesday, March 4, 2009 5:59 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, January 22, 2011 12:01 PM
Points: 702, Visits: 174
Nicely written.


Kindest Regards,

Amit Lohia
Post #668836
Posted Wednesday, March 4, 2009 9:36 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
Praveen,

Thanks for submitting this, and it came out very well. I'm sure you're helping more than a few people with this.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #668877
Posted Friday, March 6, 2009 10:06 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 6:06 AM
Points: 33, Visits: 177
I'd say yes.. Normally it won't be the case where sql service account doesn't have permissions on its own registry key.. HKLM\Software\Microsoft\MSSQLServer..

This could have happened mainly due to wrong way of account change.

Post #670811
Posted Saturday, March 14, 2009 2:13 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 5:59 PM
Points: 538, Visits: 772
Awesome piece of troubleshooting! Thank you for sharing.


Post #675973
Posted Monday, July 20, 2009 11:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 8:36 PM
Points: 1, Visits: 76
Hey Praveen,

Superb man... Really helping ppl around U
Post #756067
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse