Xporter: SIMS: Login 2 Failed – network-related or instance-specific error occurred

Summary

Resolve SIMS connection error.

Answer

Scope

Information and steps on how to resolve the error: Login 2 Failed - A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Symptoms

  • Xporter on Demand is not syncing data.
  • The reported error is SIMS: Login 2 Failed - A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Cause

Xporter is unable to locate and connect to SIMS database on the server or workstation it is installed on.

Resolution

1. Xporter uses the local SIMS application to extract data from the SIMS database. Try to log into SIMS on the Xporter server.
2. If you get an error, troubleshoot with the assistance of SIMS support if necessary, as this will also resolve the error in Xporter.

image.png
3. If you can log into SIMS using the SIMS application on the Xporter server, make sure the connect.ini file in the Xporter folder (default location: C:\Program Files (x86)\Groupcall\Xporter) matches the connect.ini in your SIMS application folder.