Are these servers in an Active Directory domain? If so, do your administrators have a group policy set that applies to these servers?

Can the new machines interface with your shared storage where the data already exists? If so, you could do something similar to (this is all high-level)...

1) Put both instances on...

Take a look at sp_helprotect (only one p). You can use this to get the permissions back for an account, for a role, for a whole DB, etc. Throw 'em...

Have you seen any unusual audit failure errors in the security log when the fail-overs stop working?

The SQL Server isn't set to case-sensitive, is it?

Both articles use OLE DB as an example to reproduce the behavior but they leave it generic to ADO in general. If you are using ADO, these could apply. Also,...

I have heard of a few cases where EM didn't get everything, but it sounds like initially you are fine but something later changes. Do you have to go in...

Brian Knight or another DTS guru might better be able to answer this, but I think you may be able to get a similar operation using DTS.

No, SQL Server Target Memory will stay the same unless there is non-SQL Server activity on that system demanding memory. In that case, the operating system will ask SQL Server...

Here's what I found in the Knowledge Base.

FIX: "Catastrophic Failure" Error Message When You Use adPromptAlways to Connect to SQL Server 2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;314635

PRB: Catastrophic Error Occurs Referencing ADO Recordset

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q187/9/42.asp&NoWebContent=1

Well, a lot depends on how security has been defined within SQL Server, especially at the database level. Are you using user-defined db roles? I hope so, because that will...

Logging cannot be turned off if you're using an INSERT command. If, however, you were to use another mechanism, such as BULK INSERT or bcp, you can take steps to...

Your SQL Servers can run under the AD domain without registering, per se. So long as the computer itself is in the domain (or a trusted domain) Windows authentication can...

You can set the IPSec policy such that you can talk to the server conducting the backups. In fact, you could open all ports, if need be. Or you could...

I've posted some links for you here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=108917