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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Jonas "Jones&q... 5,016 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 239,580 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,618 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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