Tuesday, August 22, 2017, 03:27:26
Submission Guidelines
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.
twitter linkedin stumbleupon delicious facebook digg yahoo print send
Rating Rating Rating Rating Rating
Does Database Mirroring Cause “An Existing Connection was Forcibly Closed by the Remote Host” Error? Page Rank 9 Top Articles
Rating: 0 - 0
brookmperry on Tuesday, June 9, 2015, 03:48:11, 2 Yaers Ago, Comments [0]
Sell and buy business online

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:

  • The mirroring ports are free and are not in use with any other process on either server
  • The firewall or antivirus software does not block the mirroring ports
  • Confirm that you can use TELNET using the FQDN of the server name
  • Verify that the SSL encryption is not enabled for any of the SQL Server
  • Confirm that the mirroring endpoints get managed properly
  • Check that the SQL Server error log file is present on both principal and mirror servers.

Conclusion

“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.

Comments


Not yet reviewed by any member. You can be the first one to write a review.

Leave Your Comment

 Name:


 Email:


 Comment:


captcha
 Captcha:


Author Showcase
Related Articles
QuickBooks is a full-featured accounting software package capable of handling the accounting needs of most small and big business establishments. Using this software, a business owner....
Wednesday, June 14, 2017, 20:43:26, 2 Months Ago
A Remote Procedure Call (RPC) is a communication process to allow a computer program cause a procedure to execute in another address space without a program providing the explicit....
Wednesday, June 17, 2015, 10:13:42, 2 Yaers Ago
QuickBooks error unable to add item to list. This time I want to explain some error like “QuickBooks error unable to add item to list”. The main aim of the article to....
Thursday, June 15, 2017, 10:08:41, 2 Months Ago
Competent Tech Support for QuickBooks InstallationA multi-user host installation is necessary to have access to the same company file within the QuickBooks application for the home or....
Wednesday, July 26, 2017, 23:59:52, 4 Weeks Ago
Error 0x00000050 has been termed as the blue screen of death error. If you ever see a blue screen on your computer that shows the listed error, then you know that you have a serious....
Thursday, June 11, 2015, 09:30:28, 2 Yaers Ago

Recommend This Page

Send Message
×