BizTalk 2013 R2 Configuration Issues

venkatasiva yadav 231 Reputation points
2021-03-30T07:00:23.033+00:00

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)

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
344 questions
0 comments
Accepted answer
  1. Leo Erlandsson 1,656 Reputation points
    2021-03-30T12:32:31.077+00:00

    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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest