Scenario 

 

While creating a company, the database cannot be found with the error message below:

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)

 

Solution 

 

What is the Server Setting for Network Connection ?

https://support.qne.com.my/support/solutions/articles/81000384958-what-is-the-server-setting-for-network-connection-

You may refer the link above for the knowledge base solution. 

If still not working, please refer with the solution below.

 

  1. Click OK on the error message.
  2. Go to Internet access icon location at right below of the screen

  1. Right click the icon > Open Network & Internet settings

  1. For Windows 10 and above, Go to Sharing options

For Windows 8 and below, Go to Network and Sharing Center > Change advanced sharing settings

 

  1. Go to All Networks. Dropdown additional settings.

  1. Go to Password protected sharing. It is turnd on as default.

  1. Turn it off and Save changes.

  1. The database will be found after the changes.