Have you fixed the user logins? sp_change_users_login 'report' will give you an idea of which logins aren't working. More in BOL.