Rahul Sharma: Access Azure SQL Server of UAT or Standard Acceptance Test - Dynamics 365 Finance & Operations Environment

[Blog bot]

Источник: http://feedproxy.google.com/~r/Rahul...vironment.html
==============

#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.
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 Server\Database 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 our twitter handle @CursorRun or FB page @CursorRun






If you liked the story and want to see more of this kind of content, please follow our twitter handle @CursorRun or FB page @CursorRun




Источник: http://feedproxy.google.com/~r/Rahul...vironment.html