Skip to main content

#msdyn365bc - How to access SQL database inside docker container ?

Hi Readers,

This is one of the common questions that is asked so many times. 

Question - How can I access my database inside Docker Container in SQL Server Management Studio?

There are situations where you would like to see data stored in SQL Server that is mapped for the docker container. 

There can be multiple reasons to have access the SQL Server.

In this article we will see how easy it is to access SQL Database mapped to docker container.

For this demo we are using Basic authentication with user name and password during creation of docker container.

I have a docker container with Container Name - bc171ussandbox.

This container is based on image for latest version of Sandbox environment. 

During Creation of docker container if you have selected - Use Cronus demo database on SQLExpress inside the container. 


The container creation process will install SQL Express and Restore the database inside it. In addition to that container creation command also create SQL user that is specified during docker creation with sysadmin permission.

To access database use SQL Server Management Studio. If you don't have it you can download the free version from MSDN.

Open SQL Server Management Studio - 

  • In Server Name use container name.
  • user name and password as used to login to Business central container.


Once you connect you can access the CRONUS database used in docker container as shown below.


Hope this article helps.

Let me know if you need any other details.

Regards,
Saurav Dhyani
www.Sauravdhyani.com

Comments

Post a Comment

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.