Bob,

This is a clear example of Kerberos authentication being failed.  Check for configuring kerberos on your domain.

You have a lot of documentation on support.microsoft.com for this error message.

In casee...

What i can think of is Replication.  you can setup replication and once everything is in sync you can disable replication. 

I know its a hard way.

Also you can consider...

When you have partitions it would generate snapshot seperately for every client.

Because the snapshot is different for each and every client so it tries to generate .sch and.bcp files...

Are u experiencing self blocking with system stored procedures.  Or custom stored procedures.  Sorry if the question is repeated again

How many files do you have associated with the database

In case you are not able to restore from the GUI.  Why dont u consider the option of

Restore database

Yes by changing the DB Compatibility level from 90 to 80 should work.  It did work for me long back.

Provided you have not used any features specific to SQL 2005...

The logins are always stored in the Master database irrespective of the database and the SID of the Reportuser should be different.  That should have caused the issue.

Yes kerberos patch should have caused the problem as this is a pure double hop issue.  We might have to check for the required SPN's available.

You can go ahead and change the settings from the registry but be sure that you have taken a backup of the registry before you perform any specific operation.

Stop you...

Coming to the very first point of SQL Licence.  Yes, you need licences for the DR site as well.

Secondly, yes you can have the DR site pointing to one server....

You have a detailed explanation as to why you need to turn TRUSTWORTHY ON in the BOL.

Check what security context are you using in the link server in case you are using one

Try to create a same login on the other server and give required permissions...

I dont see any reason as to why you need to have Integration services and Analysis services as a part of the clustered services.

Please check what is the protection level that you have stored.

Nice article., Would really appreciate if you can incorporate and put in the functionality of SSIS and Replication within which can enhance the application to a much higher stand.