System errors and PC problems are uncertain, and they may cause serious damages to your software and hardware components. Since availing IT solutions online isn’t the only way to resolve tech worries, you must read the article below to know about fixing some complex PC issues.
Every computer user faces tech issues and system problems now and then. You may get shocked to know that even the most stable and secure machine is not completely safe from malicious software, file corruption, and hardware failure issues. Since computer problems like device failure, sudden shutdowns, and uncertain PC hangs may interrupt your regular computing experience, you may require a computer support professional to fix such issues. Tech problems can be a huge headache as it can bring productivity to a halt and contacting a PC technician can make you pay heavy repair bills. There are thousands of possible error messages that may lead to hardware failures and an irresponsive device.
Read below to know more about “An existing connection was forcibly closed by the remote host” and its connection with database mirroring.
What is Database Mirroring?
Database mirroring is a feature that helps in increasing the availability of an SQL Server database. The entire process gets implemented on a per-database basis and only supports databases having a full recovery model. The mirroring process will always maintain two copies of a single database, and each of them will reside on different servers of SQL Server Database Engine. Both the servers reside on computers in different locations and users can easily access the items stored in them, irrespective of their geographic locations. Most of the IT solutions engineers recommend starting database mirroring to initiate a relationship that can conduct a database mirroring session between the two servers.
How the Error Occurs on an SQL Server?
Earlier, SQL Server Database Mirroring was a popular feature, and users use it in many organizations for sharing and maintaining critical databases. Computer geeks recommend sharing databases using this feature simply because it is faster and hassle free to configure database mirroring. Sometimes, the physical, as well as the wireless barriers, may create numerous problems while setting up database mirroring. You may experience the following error message if the feature is unable to configure database mirroring in SQL Server 2005:
SQL Server 2012, SQL Server 2008 R2, and SQL Server 2014:
“Msg 1418, Level 16, State 1, Line 1
The server network address “TCP://servername.domain.com:5022″ cannot be reached or does not exist. Check the network address name and reissue the command.”
Additionally, you may also get the Error: 1474, Severity: 16, State: 1 when your system confronts the database mirroring error. The error code that appears may have the following error details:
“An error occurred while receiving data: ‘10054(An existing connection was forcibly closed by the remote host.)’.’ for ‘TCP://mirrorserver.mydomain:5022”
“Database Mirroring login attempt by user ‘NT AUTHORITYANONYMOUS LOGON.’ failed with error: ‘Connection handshake failed. The login ‘NT AUTHORITYANONYMOUS LOGON’ does not have CONNECT permission on the endpoint. State 84.’ ”
Possible Causes of the Error With Their Possible Solutions
1. Create a Full and Log Backups
If you wish to protect your system from such errors, then ensure that the Mirroring partner server has the capabilities to function as a secondary server for the mirroring. Additionally, you will also need to create a full backup and a log backup of proposed principal database to avoid any loss of database files. You must restore both the full and log backups on proposed mirror server with NORECOVERY to prevent the error from occurring.
2. Identify the User Account
You must identify the user account that is being used to run the SQL Server services on your PC. Tech experts and a professional PC technician will always recommend using a domain account to run the SQL Server services. The domain account should have proper access and permission to access and modify the files in the other SQL Server and vice-versa. If you are using local accounts, then either use certificates or share the same local user on both servers.
3. SQL Server Service Accounts Has Connect Permission
If you’re planning to perform the database mirroring process on your device, then always make sure that that SQL Server service account have relevant connect permission over endpoints. Sometimes lack of connect permissions may lead to the occurrence of the error so a computer support technician will fix the issue by providing connected permissions to endpoint on both the servers.
Following are some of the factors you must ensure to avoid the occurrence of the error:
“An existing connection was forcibly closed by the remote host” error is a common Windows error that may appear on your computer screens anytime. The basic purpose of the error is to inform that a service, process, or an ongoing sharing activity gets closed by a remote host. It may appear due to the existence of computer viruses on your PC. You can take help of an online computer support firm or an IT solutions provider to resolve the issue and get rid of stubborn viruses. Ask for remote tech help and a PC technician will perform necessary troubleshooting steps to resolve your system errors and computer problems.
2 Yaers Ago, Tuesday, June 9, 2015, 03:48:11