Connecting BizTalk Azure Server to SQL Azure DB

Sean Malloy 16 Reputation points
2022-10-05T15:23:37.373+00:00

I'm trying to Configure a BizTalk Server Azure instance to a SQL Server Azure instance.

  • Custom Configuration
  • Have whitelisted the IP of the server that i'm trying to configure Biztalk for on on the SQL Server Network Settings
  • Using Database Server Name: xxxxx.database.windows.net
  • Username and pass are SQL Authentication Username and Password configured on the SQL Server Instance

I get the error:
"The database server you specified cannot be reached. Make sure you have specified the correct server name and that the server is currently running. Windows logins are not supported in this version of SQL Server."

Any suggestions here? I'm finding it hard to find any documentation outside of the happy path.

Thanks!

Azure SQL Database
Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
364 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Samy Abdul 3,371 Reputation points
    2022-10-05T15:37:39.323+00:00
    0 comments No comments

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.