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

A database synchronization failed error message indicates that the workstation is not able to communicate with the server database. This error will not prevent users from working with 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 (Start -> Run and type in: services.msc).

If the SQL Server services are running on the server, it is possible that the firewall on the server or on a workstation is blocking communications from the workstation to the SQL Server database. Please add the following exceptions to the 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