As per the article NoelD referred you to, the DTS transfer login task is your best option here.

You will just have to run sp_change_users_login 'update_one' for each user on failover.

Bet...

Panic over, copied over file MSVCP71.dll from another 2003 server (it can also be downloaded from web) and it all started fine.

So trying to start it without service gave the...

Tryinf to start SQL from command line not under a service (sqlservr.exe -c) I get the following error:

Application popup: sqlservr.exe - Unable To Locate Component : This application has failed...

probably not osama, I get the error on trying to start the service , rather than stop.

I shouyld add there were space problems on the drive the day before, but...

ok, thanks andy and 'deadwood'.

As deadwood says, work with what we got (or around it).

Ronda London (10/16/2007)

---

I usually wind up changing the owner of the jobs created by the maintenance plan in SQLAgent. I find it to be a big pain in the...

Andy,

thanks. yes it is pretty dumb, especially as SQL2000 could handle any requirements fine. I will have to layout my backups and maintenance plans to work around this foible, though...

you could just go through and change the owner of the jobs the maintenance plan creates in SQLAgent, effect will be the same.

george

ok, solved out 'cannot generate sspi context' error -

as machine had dropped out of domain we -

moved computer to its own workgroup

deleted computer name entry from AD

moved computer back to...

If you have a 9GB log in full recovery mode and are using truncate_only I would expect you to have a big empty(ish) file, which is why your log tools...

Hey guys,

I have been getting the 8344 error since the machine dropped out of the domain last week. Unfortunately it also means we are not able to connect remotely...

what a palaver! One wonders why SSIS is not cluster aware when DTS was. More work for Microsoft to do surely.

They give with one hand by making Analysis services cluster...

did not set this up myself so do not have details but...

AS400 so presume the database is DB2? You will need to install the DB2 client software on your SQL...

AN 823 error suggests a H\W error, so make sure your server guys check the disk out....

thanks michael, I'll give it a go and let you know how it pans out. Might be a while as I have to go through the management procedures and get...