I have to support an app written by a team that is now gone. We grabbed a backup of their database and performed a restore on our dev environment with said .bak file. I got their code, set it up on our IIS server and got database access errors.
I've seen this before, backup/restore will insert the users, but for some reason, they don't have access and can't be modified to have access. Usually, I just delete the user and recreate it, and it will have access. This is a little tougher with the Membership API because it uses Schemas, so I cannot delete the user without really screwing with the underlying system, and I frankly don't know enough about schemas to confidently do this. So, question 1:
How can I do a proper restore of a database and have the SQL users work without having to recreate them?
To temporarily work around this issue, I just created another user and gave it all the access it needed (to includ ...
Go to the complete details ...