Access Azure SQL Server of UAT or Standard Acceptance Test – Dynamics 365 Finance & Operations Environment

#DevOps  #Dynamics365Finance

How to Access Azure SQL Server of Dynamics 365 Finance and Operations? 

Applies to:
  • 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.

Pre-requisite 

Download SQL Server Management Studio (SSMS): We will need SSMS to access the Azure SQL instance, so go ahead and install it on your PC.
 
Lifecycle Services (LCS): You need to have atleast Environment Manager role in LCS.

Enable Access

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
Default image
Rahul Sharma
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.

One comment

  1. Wow, this piece of writing is pleasant, my sister is analyzing these things, so I am going to tell her.

Leave a Reply

%d bloggers like this: