Article ID: 123704, created on Nov 27, 2014, last review on Nov 27, 2014

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Task for adding new Microsoft SQL service node fails with:

HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

Cause

Server with already installed MS SQL Standard server was added as a service node to PPA infrastructure. This type of server can be added as external database server.

While adding service node PPA install MS SQL Express edition by itself.

Resolution

  1. Remove service node 'MSSQLNODE' in:

    Infrastructure -> Service nodes -> select 'MSSQLNODE' and press 'Delete'

  2. Await till according tasks finished

  3. Unistall application PEM from service node (using standard way through Control panel -> Uninstall applications)

  4. Remove 'C:\POA_Deploy' and 'C:\Program Files(x86)\SwSoft' folders from service node

  5. Add service node again(without pre-installed MSSQL* and if you need to have Express Edition) or add server like external database server (with previously installed MS SQL Standard or any other required edition).

For additional information please refer to our Deployment Guide:

Search Words

Error Locating Server/Instance Specified

A network-related or instance-specific error has occurred while establishing a connection to SQL Server

Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF