Backup failed SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Created:

2016-11-16 12:51:19 UTC

Modified:

2017-08-08 13:19:16 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Backup failed SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

Migration or backup of remote MS SQL Database failed with:

Unable to backup database 'db_data'
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Cause

Server misconfiguration

Resolution

  • Make sure that service SQL Browser is running on the server.
  • If the firewall is enabled on the server, put sqlbrowser.exe and/or UDP port 1434 into the exception (MS SQL Probe firewall rule)
Have more questions? Submit a request
Please sign in to leave a comment.