Timeline for user mapping is droped after swithing from principle server to mirror server
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 7, 2014 at 18:31 | vote | accept | user3213767 | ||
| Nov 4, 2014 at 16:00 | comment | added | Neghtasro |
You don't have to change anything on A as long as connections are currently working. Delete the instance-level logins on B, then use the script on A to generate the CREATE USER scripts you need. Run those scripts on B and you should be good to go.
|
|
| Nov 4, 2014 at 15:56 | comment | added | user3213767 | Thanks for replying. If Server A now the principle, i need to delete the user completely, then create it using the script which has SID option and also default DB and then map the user to the DB. then fail-over server A to switch to server B, delete the user from server B, then run the same creatUser script, then i think to map it again to the DB Name, then fail-over in server B to switch to server A. is that right as working steps ? if not please tell me the correct sequence | |
| Nov 4, 2014 at 14:41 | history | answered | Neghtasro | CC BY-SA 3.0 |