To test the connection between an Enterprise Alert server and the SQL box.
- Create a new text file on the EA desktop. Save the File as a .UDL
- Double click on the file and on the Provider tab select SQL Server Native Client 11.0
- On the Connection tab enter the Server Name and credentials for the DB user
- In the Select Database field you should see Enterprise Alert (if credentials are wrong you will get a message when trying to select the DB)
- Click Test Connection