Monday, November 30, 2020

#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

No comments:

Post a Comment

Popular Posts