web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Is it possible for SSM...

Small and medium business | Business Central, N...

Suggested Answer

Is it possible for SSMS to access cloud hosted Dynamics 365 Business Central

(0) Share

Report

Report

Posted on by mlee2020

5

Hi,

Can anyone tell me whether it's possible to access a cloud hosted Dynamics 365 Business Central via SSMS?

thanks,

Michael

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Gearoid Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Michael,

If you are referring to Business Central Online (i.e. the SaaS version of the product) then the answer is no, i.e. the SQL database is not directly accessible to customers or partners via SSMS. However, it is possible to arrange to get a copy of the relevant SQL Server database in the form of a *.bacpac file. If you need that then it will be necessary to open a ticket with Microsoft via your Solution Provider or Business Central Partner.

It is also possible to host an on-premise version of D365 Business Central on a VM in the cloud with the BC database hosted on an Azure SQL DB instance. If this is the environment you are referring to then the answer is yes, i.e. it is possible to connect directly to such an Azure SQL DB with SSMS.

I hope that helps.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,005 Super User 2026 Season 1

#2

YUN ZHU 1,148 Super User 2026 Season 1

#3

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans