Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Incorrect connection s...
Finance | Project Operations, Human Resources, ...
Answered

Incorrect connection string when verifying the connection status between D365FO and Azure Database

(1) ShareShare
ReportReport
Posted on by Ali AbdAlNasser 394
Hello everyone, I hope you are all well.
I am facing an issue in D365 and I have not found a solution for it online.
I am trying to establish authentication between D365 and Azure Database in order to retrieve data using the BYOD service. I have followed all the instructions starting from creating a database in Azure to establishing the authentication between D365 and Azure Database as mentioned in this link: D365 Finance and Operations integration using BYOD
 
But I am getting an error message: /Incorrect connection string. The connection string should be of format Data Source=serverName;Initial Catalog=databaseName;Integrated Security=False;User ID=PlaceholderUserId;Password=PlaceholderPassword/
////
Even though I am sure that everything is in the right place,
I have tried searching online and found this article: Incorrect connection string
 
But I couldn't find the Security and Networking mentioned.
I really don't know what else I can do, I would be truly grateful for any help.
 
Best regards
  • Suggested answer
    Ali AbdAlNasser Profile Picture
    Ali AbdAlNasser 394 on at
    Incorrect connection string when verifying the connection status between D365FO and Azure Database
    Hello everyone.
    In this comment, I wanted to share the solution I found to fix the "Incorrect connection string" problem.
    You can solve the issue by following these steps:
    1- Go to Azure
    2- Open Azure SQL Database
    3- Look for the Set server firewall option in the quick access menu next to the copy button
    4- Search for Security and navigate to Networking
    5- Under Public access, move the Public network access option from "Disable" to "Selected networks" and then activate the Allow Azure services and resources to access this server option
    6- Save
    It seems that my issue was due to this option, I hope this comment helps everyone.
    Best regards
  • Ali AbdAlNasser Profile Picture
    Ali AbdAlNasser 394 on at
    Incorrect connection string when verifying the connection status between D365FO and Azure Database.
    Hello Judy, thank you for engaging with the question you asked. But I couldn't find the Networking.
    Can you take a look at my Azure:
     
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Incorrect connection string when verifying the connection status between D365FO and Azure Database.
    Hi, as you mentioned, you didn't find the Security and Networking mentioned in the blog. I think you can go to settings" section, click on "Networking", In the "Firewall" tab, toggle the switch for "Enabled from all networks" to enable it. 
    You can also check the event viewer for more detailed error messages.
     
    Best Regards,
    Judy
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans