Access Business Central database running in a container from the Microsoft SQL Server Management Studio

by Jul 11, 2020Runtime, SQL

Home 9 Development 9 Runtime 9 Access Business Central database running in a container from the Microsoft SQL Server Management Studio

Whether your instances are running directly on the server or in containers, it is sometimes necessary to access a database directly from the SQL Server Management Studio. When you have everything installed on your device, it is usually straightforward – you have the database on SQL Express Server installed together with the Business Central, or the database is deployed on your existing SQL Server.

However, when you use BC Containers (with the standard setup – everything running inside the container, even database), it could be unclear how to access the database.

The first thing to know is that the database can be accessed like any other database, without any special setup.

So, how we can access the database? The most important things to know are that the database is accessible only from the computer where the container is running, and that database server name is the same as the name of your container. The same is also your user name and password (as you used to create a BC container/instance).

Access database hosted in BC container from Microsoft SQL Server Management Studio

Start SQL Server Management Studio on the computer where the container is running, set the server name to the same value as your container name and use your own credentials that you set for the container and that’s it!

Recent Articles from the category

Partial Records in detail (part 2)

This is another article about Partial Records (as we already discussed earlier in the article about Partial Records and later in the first part of articles about partial record's performance). In this article, we will explore the ration between performance, partial...

read more

Partial Records in detail (part 1)

Partial Records in the Business Central are a new technology in 2020 wave 2 release. Let's look at the quick description in one of the posts from previous month "Partial Records". Now check it in more details. In this first part, we will look at how the partial...

read more

Partial Records

Partial Records are a new capability of Business Central introduced in Business Central 2020 release wave 2. It allows specifying fields that should be loaded when accessing SQL based data. How does it work? Without using partial records, Business Central normally...

read more

Connect to Business Central Container using VS Code

In the last article, we created our first Business Central Container for development. But how to use it within the VS Code environment? There is nothing special about the configuration. Just use values from message gained once the container was created. Use a value of...

read more

Sign Up for News


Highest certification
Microsoft Data Management and
also in D365 Business Central

Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate

See other certifications here