How to Access Azure SQL Server of Dynamics 365 Finance and Operations?
Dynamics 365 Finance
Dynamics 365 Supply Chain Management
Dynamics 365 Commerce
Microsoft is making continuous changes to the Dynamics 365 ALM process, and most of the time if not every time is for good. Recently they have changed the environment accessibility and restricted access to Sandbox – Standard Acceptance Test (Tier 2-5) environments. These environments are now fully self-service environments, mimicking the production environment.
All the processes that require customers or partners to use remote access for these environments are now automated.
In this post, we will see how can we can connect to the Azure SQL Database for various reasons.
Next, we want to add our local IP address to the Azure SQL firewall.
You can do this from the Lifecycle Services (LCS) environment page.
Note: this will be active only for 8 hours.
Request Access and Get SQL Credentials
Once we have added our local IP to SQL Firewall rule, we can request the SQL access.
You can do this from the LCS environment page.
Select if you want read-only or write access.
Your request for JIT access has been successfully submitted. Your JIT account and password will appear in the credentials list in several minutes. You will need to refresh the page until they appear. Once they appear, the JIT account will be valid for 8 hours.
You will get SQL credentials along with SQL ServerDatabase Name, after submitting the request (refresh page).
Please note, this is a Just In Time account that is only valid for 8 hours. You cannot use the same account again, as system generates new credentials for each request.
Connect to the Database
Use the SQL Server, Database, User name, and Password you received to login using SSMS.
We also need to provide Database name on the Connection Properties > Connect to database.
Once this is done, you should now be connected to the Azure SQL Database.
If you liked the story and want to see more of this kind of content, please follow us on twitter @CursorRun or FB @CursorRun
Rahul is a technology enthusiast, solutions architect, trainer, and blogger, working on various Microsoft and open source solutions with more than 18 years of industry experience. He specially takes interest in designing enterprise applications, cloud integrations, IoT, and other architecture rich business solutions.