Skip to main content
Question

Each tenant has its own database

  • February 13, 2026
  • 2 replies
  • 0 views

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

2 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.