EERP programs show Proxy Encountered Error During Request Processing - SQL Services

Description of Issue

EERP programs are showing Proxy Encountered Error During Request Processing and the SQL instance or database connection fails to load.

Context
  • Munis
  • Tyler Systems Management
  • System Administration
  • SSMS
  • SQL Server Analysis Services
Cause

SQL Server service(s) unable to communicate successfully

Resolution
  1. Connect to the Database server
  2. Open SSMS and enter instance name where the Enterprise ERP database is located
    1. If there are issues connecting to the SQL instance or the Enterprise ERP database (ex: munprod), review SQL instance service(s)
  3. Open Services
  4. Scroll down to the SQL Services
    1. Ex: SQL Server Analysis Services (MSSQLSERVER) or SQL Server (MSSQLSERVER)
  5. For the applicable SQL instance:
    1. If any SQL service is stopped, right click the SQL Server service > click Start
    2. If the service is already running, right click the SQL Server service > click Restart
  6. If the issue persists, reboot the Database server