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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-30 : 09:19:04
|
| In our application, the application logs in to the database using a database login. When I mirror the database, the login is not mirrored. The worst part is that the login cannot be created even after creating the mirror database unless we stop the mirroring. Is there a way to create the login without waiting the failover to occur? |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-31 : 07:32:25
|
| Would anybody please comment on this? |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-08-31 : 23:15:44
|
| The login can be created on the other instance with no problem - your problem is that the login you are creating on the mirror system does not have the same SID as the login on the primary.Lookup CREATE LOGIN in books online. You can create a login with a specified SID - and that will then be linked to the user in the mirrored database. |
|
|
|
|
|
|
Database Mirroring doubt