Sample Header Ad - 728x90

Replication throw an error after failover mirror partner is down in SQL Server

5 votes
1 answer
960 views
Received an error mentioned below after failover when mirror partner is down. **Error :** > to fail over to a database which is not configured for database > mirroring. code: 22037, text: 'Invalid connection string > attributeCannot open database "DBName" requested by the login. The login > failed.Login failed for user 'domain\user'.The connection attempted to > fail over to a database which is not configured for database > mirroring.'. **Scenario :** 1. X is a Principal server and Y is a mirror partner of X 2. X is a publisher too, Z is a distributor server 3. Z is added as distributor in X and Y Server. X and Y added as publisher in Z server too 4. Configured Y as a "PublisherFailoverPartner" in replication log reader agent profile setting 5. Did failover of X 6. Thereafter Y became a principal and X became mirror partner 7. Break mirror from Y to X or X server is down and unavailable After above steps performed, replication is started to throw an error. When mirror is ON the replication is working, otherwise it raising an error mentioned. Can you please suggest me steps to resolve it?
Asked by Paresh (223 rep)
Mar 23, 2015, 06:24 AM
Last activity: Jan 19, 2025, 12:01 AM