Yes, I had to the the same. With help from Micorsoft they informed me I had to recreate the encrytped keys.

If you didn't backups the keys before you changed the...

Try this from the knowledge base. IT worked for me.

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

If you want to backup the password for the login you can run this script to create an SP that will script out logins & passwords.

----- Begin Script, Create sp_help_revlogin procedure...

Use <databasename>

sp_change_users_login 'auto_fix', '<username>'

I've wrttien this Stored Proc to do Differential backups and delete old backus after a set numberof days. It also truncates & shrinks the Tlog

-- =============================================

-- Differential Backup 'YourDatabase' of Database.

-- Backups...

This is what I use:

CREATE   PROC dbo.up_FixObjOwners

AS

SET NOCOUNT ON

DECLARE @dynsql varchar(1000)

SET @dynsql = ''

DECLARE @Obj_Owner sysname

SET @Obj_Owner = ''

DECLARE @Obj_Type VARCHAR(30)

SET @Obj_Type = ''

DECLARE @Obj_Name sysname

SET @Obj_Name = ''

DECLARE...