Microsoft Knowledge Base Email Alertz

(871061) - Explains that initiating Internet synchronization may cause an error when the Internet server computer is on a local area network that uses a Network Address Translation router. Edit the hosts file on the Internet server computer to fix the problem.

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 871061 - Last Review: February 9, 2006 - Revision: 3.8

You may receive the "Internet synchronizer exited unexpectedly on the server" error message when you try to initiate Internet synchronization of a Microsoft Access-replicated database



This article applies only to a Microsoft Access database (.mdb).

Advanced: Requires expert coding, interoperability, and multiuser skills.

SYMPTOMS

After you initiate Internet synchronization to exchange the data in a Microsoft Access-replicated database over an Internet connection, you may notice that the Internet synchronization is not completed successfully. Additionally, you may receive the following error message:
Internet synchronizer exited unexpectedly on the server. Look at the partner replica exchange history on the internet server to figure out the problem.
Note Capitalization and wording for this error message has been verified to match the error message that appears on the UI.

This problem occurs when all the following conditions are true:
  • The Internet server, also known as the Web server, that is running the Internet synchronizer is on a private local area network (LAN) that is connected to the Internet.

    Note The Internet synchronizer is named Mstrai40.exe.
  • The LAN uses a router that has Network Address Translation (NAT) that is enabled to communicate with the computers on the Internet.

CAUSE

The Internet synchronizer tries to communicate with the Web server by using the unique external Internet Protocol (IP) address or the domain name of the Web server. Because the Web server is in the same local area network and is configured to use the same NAT router, the NAT router cannot map the external IP address or the domain name of the Web server to the internal IP address of the Web server. Therefore, the Internet synchronizer cannot connect to the Web server to do Internet synchronization successfully.

RESOLUTION

If Internet replication is setup by using the domain name of the Web server, you can resolve this problem by editing the Hosts file on the Web server. You want to map the domain name of the Web server to the internal IP address of the Web server. To do this, follow these steps.

Note You cannot use this method if Internet replication is setup by using the external IP address of the Web server.
  1. Start Microsoft Windows Explorer.
  2. Locate the Hosts file.

    By default, the Hosts file is at the following location:

    <WinDir>\system32\drivers\etc

    Note The <WinDir> placeholder is a placeholder for the path of your Microsoft Windows folder where the operating system files run from.
  3. Open the Hosts file by using Notepad.
  4. Add the following line at the end of the Hosts file to map the domain name of the Web server to the internal IP address of the Web server.

    <IP Address> <tab character> <Domain name>

    Note The <IP Address> placeholder is a placeholder for the internal IP address of the Web server. The <Domain name> placeholder is a placeholder for the domain name of the Web server.

    For example, if the domain name of your Web server is "ReplicationDomain.com," and the internal IP address of the Web server is "192.168.150.144," you must append the following line to the Hosts file on the Web server:

    192.168.150.144 ReplicationDomain.com
  5. Save the Hosts file.

    Notice that you can successfully synchronize the data over the Internet.

WORKAROUND

To work around this problem, use one of the following methods:
  • Use a virtual private network (VPN) so that the remote computers that participate in your Access replication can connect to your Web server for Internet synchronization.

    For additional information about VPN, visit the following Microsoft Web site:

    Virtual private networks for Windows Server 2003
    http://technet.microsoft.com/en-us/network/bb545442.aspx (http://technet.microsoft.com/en-us/network/bb545442.aspx)
  • Connect the Web server to the Internet directly by removing the NAT router.

    When the users of your Access database replication try to connect to the Web server over the Internet connection, the external IP address or the domain name of the Web Server is correctly translated to the internal IP address of the Web server by the NAT router.

REFERENCES

For additional information, visit the following Microsoft Web sites:

Virtual private networking: frequently asked questions
http://technet.microsoft.com/en-us/network/cc983672.aspx (http://technet.microsoft.com/en-us/network/cc983672.aspx)
Internet synchronization with the Microsoft Jet Database Engine: a technical overview
http://msdn2.microsoft.com/en-us/library/aa140025.aspx (http://msdn2.microsoft.com/en-us/library/aa140025.aspx)
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
173685  (http://kbalertz.com/Feedback.aspx?kbNumber=173685/ ) Synchronizing Jet databases over the Internet
304026  (http://kbalertz.com/Feedback.aspx?kbNumber=304026/ ) Troubleshooting common replication errors

APPLIES TO
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnat kbreplmgr kbdatabase kbip kbtshoot kbprb KB871061
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate