Restituisci
-
Titolo
MNE Error: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified -
Descrizione
When trying to run the MNE Prerequisite Checker, some errors get generated in the Checker log as follows:
ERROR SqlServerVersionProbe - System.Data.SqlClient.SqlException (0x80131904):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)(provider: TCP Provider, error: 0 - The remote computer refused the network connection.) ---> System.ComponentModel.Win32Exception (0x80004005): The remote computer refused the network connection -
Risoluzione
RESOLUTION:
1. Make sure your SQL server name is correct, e.g. no typo in the name.2. Make sure the Migration server is reachable, e.g. DNS can be resolved correctly3. Make sure SQL Browser service is running on the Migration server.4. Disable the firewall on the Migration server.Otherwise, create an inbound rule with service exceptionfor the service sqlbrowser.exe and UDP port 14345. Check the SQL connection using the portqry tool- Get it from http://support.microsoft.com/kb/832919and run:portqry.exe -n your-Migration-servername -p UDP -e 1434Note: This tool is more/less similar to >netstat -nao