Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2011-02-02 : 09:06:46
|
| Hi,Got a mirrored DB which seems to be replicated it's actual data and stored procedures and such as expected, but it doesn't seem to mirror users. Should it? Or do they have to be created manually on each server separately?Cheers,Matt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-02 : 12:03:36
|
| Just make sure, when you create the logins on the mirror, you create them with the same SID as on the principal. Otherwise the logins won't match up with the users.--Gail ShawSQL Server MVP |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Should a mirrored DB mirror both users & logins