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

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 - 

Dynamics 365 Business Central 2021 release wave 2 (BC19) Released.

Hi Readers, As we all were expecting Microsoft have Released Business Central 2021 Release Wave 2 Today a.k.a BC19. In this article we will see what all is announced with the General Availability.  Starting Today Customers & Partners can start using Business Central 19. #msdyn365bc #bc19

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------