BizTalk 2013 R2 Configuration Issues

Question

Hi ,

We installed BizTalk server in Different system and we connecting SQL server instance with port number,

and user has Admin rights in SQL server

but we are getting below issue while configure the BizTalk server , please help..

TITLE: Microsoft BizTalk Server Configuration Wizard

---

The database server you specified cannot be reached. Make sure you have specified the correct server name and that the server is currently running. 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)

Answer 1

Hi,

First, I'd not recommend installing 2013 R2, as it is End of Support already.

Could you install SQL Server Management Studio on the BizTalk Server and try connecting to the SQL Server from there?

Also, ensure you have all SQL Pre-reqs for BizTalk installed (includinng OLE DB Driver):
hardware-and-software-requirements-for-biztalk-server-2020

Br,
Leo