From the Real World: SQL Server 2000 SP4 Installation Failure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Praveen Voleti » From the Real World: SQL Server 2000 SP4...

From the Real World: SQL Server 2000 SP4 Installation Failure

Rate Topic

Display Mode

Topic Options

Author

Message

praveen voleti

Posted Wednesday, March 04, 2009 12:49 AM

SSC 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

ryberg_b

Posted Wednesday, March 04, 2009 2:50 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 3:07 AM
Points: 21, Visits: 115

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

Ananda-292708

Posted Wednesday, March 04, 2009 4:45 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 11:23 AM
Points: 65, Visits: 342

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

elchivato

Posted Wednesday, March 04, 2009 8:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 21, 2010 11:56 AM
Points: 3, Visits: 28

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

don_goodman

Posted Wednesday, March 04, 2009 9:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 06, 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

Amit Lohia

Posted Wednesday, March 04, 2009 5:59 PM

Say 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

Steve Jones - SSC Editor

Posted Wednesday, March 04, 2009 9:36 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738

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

praveen voleti

Posted Friday, March 06, 2009 10:06 PM

SSC 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

mishaluba

Posted Saturday, March 14, 2009 2:13 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

Awesome piece of troubleshooting! Thank you for sharing.

Post #675973

ashok.gudla

Posted Monday, July 20, 2009 11:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, July 17, 2012 7:22 PM
Points: 1, Visits: 34

Hey Praveen,

Superb man... Really helping ppl around U Wink

Post #756067

« Prev Topic | Next Topic »

Permissions