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
- – Check the SQL Server errorlog file on both principal and mirror server and make sure there are no errors. Most often or not you will find the real cause of the failure here. Example is login failed due to missing grant permission over mirroring endpoint to SQL Server service account as shown below. Error: 1474, Severity: 16, State: 1.
- CPU usage reaches 100 percent on the computer, and you cannot stop the SQL Server service by using SQL Server Management Tools. You end the process of the SQL Server secondary instance by using Task Manager. You restart the secondary instance of SQL Server. In this scenario, all mirrored databases are in a Disconnected or In Recovery state.
Sql Server Error 1474 Severity 16 State 1
Error: 1479, Severity: 16, State: 2. Message The mirroring connection to 'TCP://servername:5023' has timed out for database 'dbname' after 10 seconds without a response.