Wednesday, March 6, 2013

Error: 1474, Severity: 16, State: 1. Database mirroring connection error 4 'An error occurred while receiving data: '64(for 'TCP://servername:5022'.

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

 

No comments: