We are trying to install a test server which will mirror a production server. When we restore the user database into our test server from a backup of production we encounter some problems. First the user login information for the user database is also restored. This poses a problem because the sysuserx table in the master database does not reflect these entries. Also When we try to add new login through enterprise manager we find that there might be some conflicted because of the restored user database. My questions is how do we sync the login information so when we look under logins we can see all the logins previously created for the restored user database. It sounds kind of confusing so I'll give an example.
After restoring the database from prod to our test server we can see that user yl5956 is already defined in the sysuser table for that database. Now when we go into creating login option we should see yl5956 but we don't. Now if we try to create yl5956 it will tell us that the user account already exists. Is there a way for us to sync this information so whatever login information we bring over will be displayed in enterprise manager without going directly to the table. Is there a better way to create a mirrored database? Thanks.
After restoring the database from prod to our test server we can see that user yl5956 is already defined in the sysuser table for that database. Now when we go into creating login option we should see yl5956 but we don't. Now if we try to create yl5956 it will tell us that the user account already exists. Is there a way for us to sync this information so whatever login information we bring over will be displayed in enterprise manager without going directly to the table. Is there a better way to create a mirrored database? Thanks.
