This connection method uses the standard SQL port 1433 to communicate with the database.
SQL Server Name
Enter the server\instance of the SQL server or SQLExpress database that the EMS system is using. To enter a non-default port, enter the port after the server\instance name (e.g. “192.168.1.33\SqlExpress, 16333”).
EMS SQL Database
Enter the database name of the EMS system database. After the SQL server name has been filled in, hitting the Refresh link will populate all of the available databases on the server for selection or you can manually type in the database name.
SQL User Name and SQL Password
Enter the SQL username to be used to read the data. Note: The user must have at least dataReader privileges on the tables and login access to the database.
Use Windows Authentication
Check this box to connect to the EMS database using Windows Authentication. Uncheck this box to use SQL authentication using the SQL username and password above.
Test Button
After you have setup the parameters above, click the Test button to test if a connection can be made.