make sure it is MSDE 2000:

run select @@version:

also as per post above make sure it is sp4 for msde 2000:

SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5

1 more:

check SQL Server Configuration Manager if the protocols are enabled

did you install sp1 for sql server 2005 ? what it's version\edition?

Follow the instruction from http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/e603c463-0636-4b85-8ada-c2b99f8555ac.mspx to enable Network DTC. If you have Windows Server 2003 SP1 installed, please also...

try to create sql server alias

check

Database Mirroring in SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Troubleshoot Connectivity Issue in SQL Server 2005 - Part III

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

Tell please - what is your OS\SP

and SP for Sql server 2005- edition\version too

Make sure it is SP1-

check if SPS2003 is OK about the Sql server 2005 SP1

also -...

try to run

DBCC CHECKDB

and then

DBCC CHECKTABLE

 which provided more details to

troubleshoot the error

--

When did you run  DBCC DBREINDEX last time?

USE MSDB

UPDATE sysjobs

SET originating_server = 'New_Server_Name'

will do it, no need to delete jobs (unless you'd like)

Just review code - DTS packs connections, etc

try

select

* from systypes where xusertype > 256

Due to make full set of TS commands posted above:

master..XP_CMDSHELL 'QUERY SESSION'

master..XP_CMDSHELL 'logoff sessionid'

I post additional - That will Disconnect the session without

logoff:

exec master..XP_CMDSHELL 'TSDISCON sessionid'

Good one

Not just for 'new SQL Server DBAs'

Nice try Brian,

But there is not much new ideas and info except advertisement of the Datatect 1.6 (BTW - good tool)

For example - Ok you calculated...

read:

SQL Server 2000 Operations Guide

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

Clive:

Did you hire him?

Good article:

The best -when you are not from "street".

Question that you know answer:

 who will be hired - top Sql server DBA or some nice person with very good connections but...