SQL Server Setup

Use the SQL Server Setup tool to test the server connection, change the database password, change server settings, and run a basic diagnostics check.

Note: The Edit button should only be used if you will be using Encompass with your existing instance of SQL Server. Contact Ellie Mae Professional Services before beginning this process.

ClosedOpen the SQL Server Setup Tool

  1. On your Windows task bar, click the Start menu or Start icon, navigate to the Ellie Mae Encompass program folder, and then click Admin Tools.
  2. Double-click SQL Server Setup.

ClosedTest the Connection to the Server

When the test is complete, a message box indicates the results. If the test failed, first ensure that the SQL Server is running, and then retest the connection.

ClosedChange the Database Password

To prevent unauthorized or accidental access to your data, you may want to change the default database password.

  1. On the SQL Server Setup tool, click Change Password.
  2. Type the old (current) password.

The first time you change the password from the default password that was created during Encompass installation, the Old Password field will be unavailable.

  1. Type and re-type the new password.
  2. Click OK.

ClosedRun a Diagnostics Check

  1. Click the Run Diagnostics button, and then click Yes.
  2. On the Encompass Database Diagnostics window, review the Database Statistics and Database Health information.
  3. If the Database Consistency Errors value is NOT 0, your database is corrupt and there is a potential for lost data. Contact Ellie Mae customer support immediately.
  4. If the Database Fragmentation Value is high, very high, or extreme, it is recommended that you defragment your SQL Database. Click Defragment, and then click Yes.
  5. Click the Refresh icon to update the Database Health information.
  6. When finished, click Close.