Service Pack Installtion

[olutimi]

Please Help Urgent

SQL Server 2000 I am updating to SP 3 from SP2 installation failed.

SQL Server terminated unexpectedly.
I have backups before install.

Please advice. SQL 2k on WIn 2k 2p3.

Urgent

[MAK]

1. what is the error message?
2. did you anything on the log?
3. what services did you stop before installing SP3

[olutimi]

Thanks for the prompt reply.

On installation of SP 3, it returned Error tat time expired during the validating of sa password. It said verify you can start server and that sa password is ok.

Service control manager failed on starting sql server service. It reported that sql server terminated unexpectedly.

I stopped the following services, SQL Server, SQL Server Agent, MSDTC and SQl Search Service.

Thanks for your help.

[MAK]

reinstall SP3.

when it asks for authentication, choose windows authentication.

what was the in the eventviewer? any other error message?

[olutimi]

Thanks.

In Event Viewer The message was MSSQL SERVER terminated unexpectedly and it is taking 0 corrective action.

In the error log, It says
Atempting to initialize Distributed Transaction Coordinator.

I hope this helps better.

Thanks.

[olutimi]

Hi Mak,

I found this in the SQL Server Error Log File on closer look.
Fialed to obtain TransactionDispenserInterface ResultCode - ox8004D1B

The error below i found in the exception log file.
spid 0 Exception 0XC0000005 Exception_Access_violation at 0X00490338

Thanks for your kind help.

[olutimi]

Hi Mak,

Am looking forward to your reply.

Regards

[MAK]

Follow this

http://support.microsoft.com/default.aspx?kbid=811168

http://support.microsoft.com/default...b;EN-US;330022

http://support.microsoft.com/default...b;en-us;810343


BTW what sps is on windows? See whether there is a conflict

[MAK]

try installing SP3a

[olutimi]

Thanks Mak.

I have reinstalled SP3A and same error message. I have SP 3 on the WIN (Advanced)2K.
I will reinstall the SQL Server and restore my System and Users databases since I took backup before SP application.

Thanks.

[MAK]

add your login as local admin and make sure you login is a sytem admin in the sql box and install SP3 or SP3a

[olutimi]

Thanks Mak.

I have reinstalled SQL2K with SP 2 and restored my Databases. The DBs are ok.
I would reinstall SP 3 at a future date.

The error was described by Microsoft in the article below.
http://support.microsoft.com/default...&Product=sql2k


Thanks for your help.