When I start the software, I get the following alert: "An error occurred when synchronizing the network database."

A database synchronization failed error indicates that the workstation is not able to communicate with the server database. This error will not prevent users from utilizing the software. However, the sharing function of the software will be disabled.

Please verify that the SQL Server (TRANSOFTSERVER) Service is started and running on the server.

If the SQL Server services are running on the server, it is possible that the firewall on the server is blocking communications from the workstation to the SQL Server database. Please add the following exceptions to the server's firewall:

  1. Port Number: 1433
  2. Applications: sqlservr.exe, sqlbrowser.exe

For Windows Firewall, the procedure is as follows:

  1. Browse to Control Panel -> Windows Firewall
  2. In the Windows Firewall dialog box, click the Exceptions tab
  3. Click Add Port then enter the following:
    - Name: SQL
    - Port Number: 1433
    - Protocol: TCP
  4. Click OK
  5. Click Add Program -> Browse, then add the following:
    - C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
  6. Click OK
  7. Click Add Program -> Browse, and add the following:
    - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
  8. Click OK

NOTE: For the newer version of Windows firewall, please add the new Inbound rule for the TCP port 1433.
On 64-bit systems, the paths for the sqlbrowser.exe and sqlservr.exe files are:

  • C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe
  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe

 

0 Comments

Article is closed for comments.