Skip to main content

How do I configure an External SQL Connection?

The Eclipse Pro dashboard allows you to configure external database connections for integrations with other systems. Setting up a SQL Server connection ensures your system can securely communicate with external databases.

http://localhost:8080/

From the main dashboard:

  • Go to Settings
  • Select Integration
  • Click on the External Connection tab

This is where all external connections are managed.

Adding a New Connection​

To create a new external SQL connection:

  • Click the “+” button to add a new connection

Add connection

Configuring the Connection​

Fill in the required fields with the following settings:

Basic Configuration:

  • Type: Database Connection
  • Enabled: ✔ (Checked)
  • Name: Enter a descriptive name for the connection

Connection String: server=SERVERNAME\INSTANCE;database=Databasename;user id=USERNAME;password=PASSWORD;trustservercertificate=true;

Additional Settings:

  • Database Type: SQL Server
  • Plant Code: Enter if applicable

New connection

Saving the Connection​

  • Click Save after entering all required information

Once saved:

  • The new connection will appear in the External Connection list
  • The system will attempt to establish the connection automatically

Verifying the Connection​

After saving, confirm the connection is working properly:

  • Locate your connection in the list
  • Check for any status or error indicators

If there are issues:

  • Errors will be displayed in the External Connection Events section
  • Review the error details to troubleshoot connection problems
warning

If the connection fails, verify your server name, credentials, and network accessibility. Ensure SQL Server allows external connections and that the correct instance name is used.

Completion​

Once configured successfully:

  • Your external SQL connection is ready for use
  • The system can now communicate with the specified database

List screen

For additional support or issues, contact support@amscontrols.com.