any special instructions when doing this on a ms cluster?   or is it the same

Thanks I will try the EM on another machine.  It just happened, perhaps as a result of changing the IP address of the server.  Everything else seems to work just...

Thanks, but the user is owner of a whole bunch of stuff. 

Someone told me to use

sp_change_users_login 'Auto_Fix', 'username', NULL, 'passwork'

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.asp

It worked like a charm.  The user in the...

That fixed it

thanks

thanks for you quick reply!