When you backup DB on SQL server A and restore it on SQL server B you may encounter problems.
Here is some tips that have helped me.
User that you have put in your connection string must be:
1. Delete it from Security / Users of your Database
2. If does not exists in SQL Server B Security / Users create it
3. DO NOT MAKE any user mapping of this user in step 2. Just create user
4. Go to Properties of SQL Server B and select Files. Change DB owner to your conn.str. user.
This should work now.
Generally you should have dbo owner & Public rights for your user in user mapping in Security tab of your database.
Step 1 is obligatory ! Proven ...
http://www.mssqltips.com/sqlservertip/2620/steps-to-drop-an-orphan-sql-server-user-when-it-owns-a-schema-or-role/
No comments:
Post a Comment