Would like to get updates as you proceed.

MJ

Try specifying a log file under the job logging option and see if it logs helpful error message there.

MJ

How to remove a failover clustered instance (Setup)

http://msdn.microsoft.com/en-us/library/aa216166(sql.80).aspx

There is however one known issue with build 2187 of SQL Server 2000 as described here, so you may need to apply this...

You can create covering indexes in 2000. See -->http://www.sqlusa.com/bestpractices/coveringindex/

If you applied the script before database restoration then they will get mapped automatically.

MJ

Is your CPU the same as listed at -->http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/35f3f460-9168-401f-bca5-16536b6ad7fe/

MJ

Hope this works for you:

Create TABLE #db_file_information(

fileid integer

, theFileGroup integer

, Total_Extents integer

, Used_Extents integer

, db varchar(30)

, file_Path_name varchar(300))

-- Get the size of the datafiles

insert into #db_file_information

(...

From-->http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Error Message 2:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused...

What is the edition of sql server? Also, check sql error logs.

MJ

As long as you have space on any 1 mdf and any 1 ldf file(or the drive where they are residing if max size restriction is not there) then you...

Are there any memory related errors in sql server error log?

MJ

Please do check sql server error logs and event viewer logs for any errors. As another poster has posted "check for any service restart".

MJ

Is distributed transaction coordinator (MSDTC) service started on your machine?

Check the com+ applications on the machine-->my computer (Control panel\administrative tools\Componant services\Computers\My Computer\Com+ Applications).

MJ

I am replying here as I am not able to view your last reply posted on

http://www.sqlservercentral.com/Forums/Topic669605-146-1.aspx

Is that upgrade problem resolved? If not then locate instmsdb file and specify a...

TYpe gpedit.msc at the run command of the machine where your are performing the upgrade. Go to COmputer configuration-->windows settings-->security settings-->Account Policies-->Password....

Or

Just use a strong password.

MJ