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.
365 questions
0 comments No comments
{count} votes

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.