Article ID: 118252, created on Oct 28, 2013, last review on May 5, 2014

  • Applies to:
  • Operations Automation

Symptoms

POA 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

There may be many reasons of the problem:

  • MS SQL services are stopped on the server where the MPS database is located
  • The server where the MPS database is locate stuck or is 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 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.

Search Words

MPS

MSSQL

SQL Server does not exist or access denied

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF