Search Engine: Elastic

Article ID: 118252, created on Oct 28, 2013, last review on Dec 28, 2016

  • Applies to:
  • Operations Automation

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.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF