Skip to main content
Question

Each tenant has its own database

  • February 13, 2026
  • 5 replies
  • 0 views

davetaylorcat
Freshman I

We have a need to completely isolate data between tenants into separate MS-SQL databases. As an example Company A and B cannot share a database due to parent company regulations. The two tenants will share a single instance and each set of tenant data will reside in a separate DB, e.g. DBA and DBB.

The installation documentation reads: “ The following diagram shows an architecture with multiple application instances. Each instance has multiple tenants, and each tenant has its own database.”

Here is the documentation link: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=4b65b79b-e09d-46bd-9a85-7c1c0bb4eba5

I see that instances are tied to a single database and I do not see a way to get the desired configuration as described in the documentation.

Can someone please help me? Either how to get the desired configuration or a concrete refutation of the documentation.

Thank you

5 replies

darylbowman
Captain II
Forum|alt.badge.img+16

If it weren’t for the graphic, I would suggest this was a typo. I’m not aware this is possible, but I believe it could be. If it is, it’s very uncommon. You may need to contact Acumatica support directly.


Forum|alt.badge.img+3

Hello ​@davetaylorcat as per my research : the documentation is technically correct but poorly worded. You cannot achieve "one instance, one URL, multiple databases" - that configuration doesn't exist in Acumatica. You need separate instances for separate databases, which means separate URLs/virtual directories.

 

You may check post for clarification:
 

hope it hepls.


davetaylorcat
Freshman I
  • Author
  • Freshman I
  • February 14, 2026

@darylbowman and ​@Abhishek Niikam Thank you both for your quick responses. I feared that the single instance single database was the official configuration. Pretty much everything else I have found proved that out except for that one sentence in the documentation. Being new to the Acumatica space and coming from other ERP packages, having this community as a resource is a great help.

Again, I appreciate your help with my topic.


Forum|alt.badge.img+8
  • Semi-Pro I
  • February 14, 2026

@davetaylorcat !--startfragment>

To clarify for everyone checking this post:
An Acumatica instance and its tenants share the same database. If the policy requires separate databases, then each company must have its own dedicated Acumatica instance.

!--endfragment>

 

 


darylbowman
Captain II
Forum|alt.badge.img+16

 

​To clarify for everyone checking this post:
An Acumatica instance and its tenants share the same database.

As the third person essentially saying the same thing, I don't think this clarifies anything unless you have a solid source indicating Acumatica definitely does not support a multi-tenant instance that doesn't share a database, especially since the documentation from Acumatica indicates they do.

Can you provide one?