Adi is correct. define the location where the log backups will be held as a share and define that share as a resource in cluster administrator.

do you still have the original instance? If so could you try this?

add a new SQL login to the original instance

rerun sp_help_revlogin

extract out the create login statement for your new...

well that format looks correct.

I can only think the app expects the server name built into the password somehow?

honestly I've used help_revlogin lots of tines without problems.

I guess like most I just started out using SSC as a great source of info and then decided I should try and give something back (which speeds up the...

thats odd, if check_policy = off that rules out that area as a cause of the logon failure.

I am at a loss to explain why sp_help_revlogin would fail to set...

did the script set their default databases correctly? Do you have the exact login failure error as recorded in the SQL errorlog?

Judy, there were lots of problems with maintenance plans with SP2, please apply at least GDR2.

that security hotfix - I am pretty sure was MS08-052, but I'm not 100% sure...

Ah, the $64,000 question that has annoyed dbas about SQL 2005 for a while now, whether or not to apply cumulative updates. You will note that microsoft says not to...

whilst SQL is shutdown the data in the table is not going to change, so rather than try to capture it on shutdown, which is difficult, capture it on startup...

approaching from a different angle................

what EXACT version of SQL are you on? I would be surprised if you had come across a new bug after all this time. The last...

I've not heard of this failing to work before.

was this a 2005 to 2005 transfer?

do the two servers have the same sort order?

what error message did users get when first...

is the sp_configure option AWE enabled set on for you? (= 1). The one time I had problems with agents xp option it was because awe was enabled but the...

you're welcome

no guarantees but two possibilities come to mind -

is autogrow set at a percentage or an amount in MB? If a percentage autogrow will have more work to do...

microsoft supply a well known script to do copy logins with the same sids and passwords - sp_help_revlogin

see http://support.microsoft.com/kb/918992