> Did a remote backup of a database used to run a live website.
> Restored the database to my local MSDE installation.
> Now cannot access the local database using the user login FRED, which is
the
> same as the website, as I use it for local testing. Get error message:
> cannot open user default database login failed.
> Cannot see FRED the user anywhere, yet if I look under Roles, FRED is
listed
> as a db_owner.
> If try and add FRED, get error saying User or Role already exists on this
> database.
> How can I reactivate FRED on my local server?
>
>