Re: mirroring database user account problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

Answered in .tools by Ekrem and Tibor.

"ken" <kenken2@xxxxxxxxxxxx> wrote in message
news:uNEqZMRDJHA.3392@xxxxxxxxxxxxxxxxxxxxxxx
I setup a mirroring database, have principal (host A), mirroring (host B),
withness (host C)

i create a user account and login account "usera" can login can retieve
data
in principal server (host A)

when occur failover to host B, host B become principal, but i can connect
host B using "usera", i saw host B have a user account "usera" in host B,
but haven't the login account, then i create login account "usera",
but the "usera" login account only can login only, can't access database,
anyone can help,

Many many thanks.


.

Relevant Pages