Symptoms

OA tasks to provision services through the MPS (Microsoft Provisioning System) fail with the following error message:

SQL Server does not exist or access denied.

Cause

The issue can be caused by the following factors:

  • MS SQL services are stopped on the server where the MPS database is located
  • The server where the MPS database is located stuck or down
  • No connectivity between the MPS Provisioning Engine server and MPS database server

Resolution

  1. Make sure that the MPS database server is up and running.
  2. Login to the server where the MPS database is located.
  3. Open Start > Administrative Tools > Services
  4. Make sure that the following services are started, start them if necessary:

    • SQL Server
    • SQL Server Agent
  5. Check if the MPS database server is reachable from the MPS Provisioning Engine server (if these services are deployed on different servers) and the TCP port 1433 is open in the firewall for connections between these two servers, e.g. use the 'telnet' utility on the MPS Proisioning Engine server to check connectivity:

    telnet MPS_DB_SERVER 1433
    

    replace MPS_DB_SERVER with the actual IP of the MPS database server.

Internal content