Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Dynamics 365 general forum / CRM database,
Dynamics 365 general forum

CRM database,

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hey..

I work for an international organization and considering to implement Dynamics CRM 365 byt have one question we couldn't answer yet, 

We work in special sector where in some countries we are required by law to host data inside the country, if we create an organization per country,  is it possible to host each organization database into a separate SQL server? in a different network? knowing that we have full control of networks. Or at least can we save a db files (mdf, ldf) on a different physical server than the one running the service?

Thanks

  • Verified answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at
    RE: CRM database,

    @john6655 no it's not and that random spam link (for SEO purposes) doesn't provide any information.

    Going back on topic I do think you need to have a proper conversation regarding using the cloud as that is the future of Dynamics 365 (the silence from MS regarding the future of on-premise is very telling). There was a talk about it at Inspire which you can see at myinspire.microsoft.com/.../776f6965-da98-474b-a305-1937cd8ad864 alongside a slide deck which should help you with framing the discussion...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM database,
    [deleted]
  • Verified answer
    Wayne Walton Profile Picture
    Wayne Walton 13,728 on at
    RE: CRM database,

    That's literally impossible.  If you require separate databases, you require completely separate installs.  You can only have one database server per app setup (excluding load balancing and the like, which isn't what you're asking about), so if you need physically isolated databases, you need completely separate CRM installs, top to bottom.

    However, I reiterate that you could just use Dynamics 365 Online and accomplish this far cheaper and easier.  Especially if you're going to be cloud-hosting all the servers anyway.  Look here at tenancy and multiregional instances.  You get to managed everything on the back end together, but on the data side, you can keep each database in the appropriate geographic area.  https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/multiple-online-instances-tenants

    Also, MS's regional datacenters are certified to hold government data in many cases, which fulfills your requirements, and has MS's backing of support.  You can see which centers hold which certifications here: https://www.microsoft.com/en-us/trustcenter/cloudservices/dynamics365

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM database,

    Thanks for your swift replies, 

    The data we deal with is somehow counted as governmental so we need to maintain it within the country, but we don't want to have multiple application servers for many consideration (including maintenance, cost,..)

    So we trying to find a way to have one application server and to host each organization database within its country (one organization per country), as far as I did read CRM creates a db per organization, so the question, does it support to have those dbs in different servers?

    We plan to host dbs at Amazon, Microsoft, or Google based on availability. 

  • Suggested answer
    Wayne Walton Profile Picture
    Wayne Walton 13,728 on at
    RE: CRM database,

    Ben has the right of it for on-premises installs.  They have to be completely separate all the way through.

    If D365 Online is an option, look up how Microsoft handles tenancy, and if MS's server infrastructure adheres to local laws.  Quick and dirty rule of thumb there, if MS has a datacenter in that country, they're also set up for all regulatory rules in that country.  That way, you could turn on an org for each country but be able to manage it under one Office 365 account.

  • Suggested answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at
    RE: CRM database,

    If you really have to host the servers in a particular country you can't just host the organizations in separate databases, you will need to duplicate the entire environment (both SQL server and the CRM servers) in every country.

    My advice would be to investigate exactly what the requirements are for each country as often there is a lot of detail within the requirements which will give you more or less flexibility depending on what the requirements actually say...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans