Hello, I'll like if you can help me, because I don't found articles where explain how do the replication with suscribers in other places(city, country, etc) , because I want to do it that, how as backup automatic. Thanks.
I have done all the setups. Mirror also configured, after failover the instance it is not replicating to subscruber.
Returing "Cannot open database "StroreDB" requested by the login. The login failed.
Login failed for user 'sa'.
I have done the below script also.
SQL
sp_changedbowner 'sa'ALTERAUTHORIZATIONON DATABASE::[StroreDB] TO sa
still it is returning the same error.
in the replication monitor "Agent 'FI2-PC\FI2INS2-StroreDB-1' is retrying after an error. 99 retries attempted. See agent job history in the Jobs folder for more details."
Please give me a solution for the same.
Thanks,
JSaraboji.
Last Visit: 31-Dec-99 18:00 Last Update: 31-May-24 18:06