Article ID: 116012, created on Apr 25, 2013, last review on Aug 30, 2015

  • Applies to:
  • Operations Automation 5.5
  • Operations Automation 5.4

Symptoms

OA tasks to provision Windows services like Hosted Exchange or SharePoint through the WPE (Windows Provisioning Engine) fail with the error message 'A network-related or instance-specific error occurred while establishing a connection to SQL Server'.

More detailed error message looks like this:

Provisioning request failed. A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Type: System.Data.SqlClient.SqlException.

Cause

WPE is using MS SQL Server database to store internal data. The reason of the problem is that WPE cannot connect to the MS SQL database which is configured in properties of the POA package WindowsProvisioningEngine installed on the WPE host.

The problem may be caused by network connectivity troubles or MS SQL server being down.

Resolution

Solve the problem with connection from the WPE server to the MS SQL Server where WPE database is located:

  1. Log into OA Provider Control Panel.

  2. Go to Deployment Director > Server Manager > Hardware Nodes in OA 5.4 or Infrastructure > Hardware Nodes in OA 5.5.

  3. Click on the WPE host.

  4. Switch to the Packages tab.

  5. Click the icon right to the WindowsProvisioningEngine package.

  6. Switch to the Package properties tab.

  7. Find the MS SQL Server hostname in the wpe.sql.servername parameter.

  8. Make sure that MS SQL Server is up and running on the discovered host and the WPE database is mounted.

  9. Make sure that the Named Pipes protocol is enabled in MS SQL Server, use the SQL Server Configuration Manager to check.

  10. Make sure that ports 1433, 1434 are open in firewall for connections from the WPE server to the MS SQL Server.

Search Words

SOAP Error: Server, HTTP Error

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

tasks

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e ac82ce33439a9c1feec4ff4f2f638899

Email subscription for changes to this article
Save as PDF