While configuring database mirroring I encountered the below errors
Error: 1443, Severity: 16, State: 2. Database mirroring has been terminated for database 'databasename'. This is an informational message only.
Error: 1474, Severity: 16, State: 1. Database mirroring connection error 4 'An error occurred while receiving data: '64(for 'TCP://servername:5022'.
Workaround on our environment to fix the issue.
1. Verify whether you are able to register the server instance on both principal and mirror servers
2. Add entry to hosts.etc file on both servers (principal,mirror)
3. Local Area connection - status - properties - select IPV4 - properties - advanced - DNS
Under Append these DNS suffixes - Click Add and add the DNS Suffix of the principal server on mirror server and vice versa.
4. Try configuring mirroring
Error: 1443, Severity: 16, State: 2. Database mirroring has been terminated for database 'databasename'. This is an informational message only.
Error: 1474, Severity: 16, State: 1. Database mirroring connection error 4 'An error occurred while receiving data: '64(for 'TCP://servername:5022'.
Workaround on our environment to fix the issue.
1. Verify whether you are able to register the server instance on both principal and mirror servers
2. Add entry to hosts.etc file on both servers (principal,mirror)
3. Local Area connection - status - properties - select IPV4 - properties - advanced - DNS
Under Append these DNS suffixes - Click Add and add the DNS Suffix of the principal server on mirror server and vice versa.
4. Try configuring mirroring
No comments: