hi,

i'm interested to know more about applying collation sequence change at the server level, as discussed here ...

but want to ask how would de-tach/re-attached of database work here? or...

ok, gotcha,  joachim, thanks for the clarification

thanks joachim - just confirming, are you saying sa will expire even if "enforce password expiration" is not checked but "enforce password policy" is checked?

Hi Terry - have you progress further/had any success with this?

May already be in place but just in case if you've checked that:

- remote server accepts windows auth (ie allow...

Jo,

as it turned out, it was due to the provider options on A: After disabling all the provider options (except for 'Allow inprocess' ) was able to proceed with...

No ( - should have read the workaround earlier) - as what's described there, is already in place ie msdtc service running as Network services, msdtc had been configured to allow network transaction (and firewall is...

Thanks indeed for this Jo.

It is windows 2003 for both. Will try the workaround.