Finance | Project Operations, Human Resources, ...

Azure SQL connection from Data Management framework

(2) Share

Report

Posted on by CU15051155-0

262

I was able to connect with azure sql from sql server management studio, but when I try to connect from Data Management framework, I am getting the below error.

The connection string provided is correct which is I used in SSMS.

I need help to resolve this issue.

Regards,

Durai Murugan R

Categories:

Microsoft Dynamics AX

Screenshot 2025-0...

I have the same question (0)

All responses (4)

Answers (0)

Jonas "Jones" Melgaard 4,894 Super User 2025 Season 2 on at

Like (0)

Report

D365 FO - Azure sql connnection from Data Management framework

Hi Durai,

I'm unable to see your attached file.

Are you sure the connection string from SQL Server Management Studio is the same as the format it requests?

Was this reply helpful? Yes No
Martin Dráb 236,788 Most Valuable Professional on at

Like (0)

Report

D365 FO - Azure sql connnection from Data Management framework

Please give us some context.

Is it about BYOD?

Are you trying to configure it for the first time or is it something that stopped working? If the latter, what has changed?

What kind of F&O environment is it?

Was this reply helpful? Yes No
CU15051155-0 262 on at

Like (0)

Report

Azure SQL connection from Data Management framework

Hi

It is for the BYOD connection, and it is resolved now. It seems to be some credential issue on the server. Thanks for the replies.

Regards,

Durai Murugan R

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,191 Super User 2025 Season 2 on at

Like (0)

Report

Azure SQL connection from Data Management framework

Hi Durai,

The connection string provided is incorrect.

For Azure SQL you need to provide the below mentioned connection string.

Integrated Security=False;Encrypt=True;Connection Timeout=30;Data Source=<azuresqlinstancename>.database.windows.net;Initial Catalog=<databasename> ;Integrated Security=False;User ID=<sqladminusername>;Password=<sqladminpassword>

For eg: For Azure SQL you need to provide the below connection string.

Integrated Security=False;Encrypt=True;Connection Timeout=30;Data Source=dmosqlinstance.database.windows.net;Initial Catalog=dmosqlbyod ;Integrated Security=False;User ID=sqladmin;Password=<sqladminpassword>

Validation steps (For access rights):

To validate the connection and the access rights, in SQL Server management studio use the below mentioned steps.

Provide the database name under Connection properties tab in the SQL Server Management studio and this should work. Post that provide the connection string in D365 and validate the connection.

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No