Unable to Connect Add-On Computer with SQL Database
This article helps Webgility Desktop users in troubleshooting issues when they are unable to connect an add-on computer to the existing SQL database used by Webgility Desktop. It outlines common causes such as incorrect credentials, network or firewall restrictions, and server-side problems. Users are guided through detailed steps to configure firewall settings, ensure application exceptions, and correctly authenticate with the SQL server to establish a successful connection.
Multiple reasons could be why you may not be able to connect your add-on machine with the SQL database, and here are a few:
1. Incorrect database credentials
2. Network issues
3. Firewall restrictions
4. Database server issues
5. Database is down
Mentioned below are a few troubleshooting methods to try in order to connect your add-on user with the existing SQL database.
Troubleshooting:
- Go to C:\Webgility\UnifyEnterprise and right-click on ‘WgFirewall’ and run the application as administrator.
- This needs to be done on both computers, primary and add-on.
- Go to the Start menu on the computer where the SQL server is installed (primary computer) and open Control Panel go to System and Security then click on ‘Allow an app through Windows firewall’.
- Click on Change Settings.
- You can also add Unify and unify scheduler apps for exceptions, they are located at C:\Webgility\UnifyEnterprise.
- Check mark all check boxes (Public, Private, and Domain if it's there) for all Webgility apps,
- eccPortalPort,
- eCCSqlBrowser,
- eCCSqlServer,
- eCCSqlServerTcpPort
- eCCSqlServerUdpPort.
- Now go to your add-on computer and log in to Webgility.
- Upon logging in, you will be asked to install the Webgility Database or choose an existing database. Since you already have a database on the primary workstation, go ahead and click on 'Connect to an existing SQL Server’. Use the 'Locate SQL Server' drop-down to choose your existing SQL server. If you do not see the desired database in the list, click Browse for more options and it will load the database available in the network.
- The existing SQL server should look like your Computername\databasename. The computer name will be the name of the main computer, and the database name will be the name of the Webgility database (note: this is usually "UNIFY or WEBGILITY").
- For the authentication mode, please select Use SQL Server Authentication, enter the username and password mentioned below, & click Connect.
- Username: sa (both lowercase)
- Password: Webgility2011 (W is in capital letters)