September 24, 2009 at 4:43 am
I've just completed an in-place upgrade of our sql 2000 database to sql 2005 which went fine, all working as it should be. Then proceeded to upgrade to SP2, again everything upgraded fine except the database engine which failed and currently remains on the base install version 9.0.1399. The only issues I appear to have is that any maintenance plans I create error when run, however, I can create T-SQL scripts and run as jobs (DB Backups, Transaction Log Backups etc).
The upgrade summary.txt contains the following:
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29565
Error Description : MSP Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance MSSQLSERVER and complete the setup.
All database services are running fine with no errors. When I follow the advice in the error description and reboot it still fails to upgrade the database engine to SQL Server 9.0.3077.
Any ideas guys as I'm pulling my hair out
September 24, 2009 at 4:49 am
this link might help.
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-setup/8970/Error-when-installing-KB948109
if you are using a domain account for the sql server service, you can try changing it to local system and restart the service then try the service pack again.
try this link as well, for ideas
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 24, 2009 at 4:57 am
Thanks silverfox, I'll give that a go
September 24, 2009 at 9:08 am
Change the Reg Key to 0 in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer\MSSQL.1\Setup\Resume
September 28, 2009 at 6:14 am
Thank's for help guys all sorted
September 28, 2009 at 6:41 am
rob.darcyburt (9/28/2009)
Thank's for help guys all sorted
for the benefit of anyone with the same problem in the future, how?
---------------------------------------------------------------------
September 28, 2009 at 7:03 am
Change the Reg Key to 0 in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer\MSSQL.1\Setup\Resume
September 28, 2009 at 7:17 am
cheers rob.
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply