Aug 22, 2019 06:25 AM|Yongqing Yu|LINK
According to your description, the reasons for throwing this issue could be wrong server name, disabled remote connection and firewall blocking.
You can follow the steps below to solve this issue, you can also refer to this link : provider:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
1.Check the server on which SQL Server is running can be accessible. You can use ping command to test that. For instance, ping <computer_name> or ping <IP_address>.
The ping command may be block by the firewall, make sure ICMP is enabled in the firewall, you can refer to this link: Windows Firewall
2. Choose appropriate protocol.
3. Configure Windows firewall accordingly based on what protocol you have chosen to use. For detailed information about how to configure Windows Firewall to allow SQL Server, please check Configure
the Windows Firewall to Allow SQL Server Access
4.Enable SQL Server Browser Services
You need to enable SQL Server Browser Services if the following are both true:
If you have enabled SQL Server Browser Services, you still need to open UDP 1434 port which is used by Browser Services in the Windows firewall.
You can also refer to this link : SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified