Data Mirroring sql server user account haven't use when failover to mirroring database
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
- Re: mirroring database user account problem
... i create a user account and login account "usera" can login can retieve ... in principal server (host A) ... but the "usera" login account only can login only, can't access database, ...
(microsoft.public.sqlserver.connect) - Re: mirroring database user account problem
... i create a user account and login account "usera" can login can retieve data ... in principal server (host A) ...
(microsoft.public.sqlserver.connect) - Re: private sharing in win xp sp2 workgroup
... host pc. ... Add the user account you wish to deny local logon to. ... Setting 'Deny logon locally' may remove it from the welcome screen. ... Name the new value exactly as the Username ...
(microsoft.public.windowsxp.network_web) - Re: home lan
... The user account for the host I can't access, ... >>has zonealarm pro. ... > machines and is that user account a member of the repective machines ...
(alt.os.windows-xp) - Re: Network Sharing with XP Pro
... Try deleting the user account ... for 2nd pc on the host and then re-enter it. ... Connection Sharing. ... >> PC is able to access files on the shared PC but not ...
(microsoft.public.windowsxp.security_admin) |
|
