question

venkatasivayadav-2961 avatar image
0 Votes"
venkatasivayadav-2961 asked venkatasivayadav-2961 commented

BizTalk 2013 R2 Configuration Issues

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)

biztalk-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeoErlandsson avatar image
0 Votes"
LeoErlandsson answered venkatasivayadav-2961 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your suggestion and it's go resolved once enable the TCP protocol in SQL server management and firewall port access from Network.

0 Votes 0 ·