Base solution for your next web application
Open Closed

Database Per Tenancy #1179


User avatar
0
tohri created

HI,

I am trying to implement multiple database tenancy. For each tenant i want a separate database and all those databases should have its meta data stored in the default database. Your framework claims to do so but when i try to create database for a tenant while creating a tenant i get an error. In order to create new tenant we are suppose to mention the connection string "Database connection string (Optional)". I have given the connection string for the tenant as follows : Server=localhost; Database=RadTenant1; Trusted_Connection=True; It do makes the database at the back end but throws an error.

Please guide me how to go for multiple database tenancy.

Thanks! Tarun Ohri


3 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    Can you share the error you are getting ?

  • User Avatar
    0
    ismcagdas created
    Support Team

    I also suggest you to read this blog post before moving to database per tenant approach, if you haven't already. <a class="postlink" href="http://volosoft.com/aspnet-boilerplate-v0-9-and-aspnet-zero-v1-10-have-been-released/">http://volosoft.com/aspnet-boilerplate- ... -released/</a>

  • User Avatar
    0
    david created

    I was having error too while testing db per tenant. What solved me the issue on my dev machine, was to enable TCP/IP connections to the sql express server: <a class="postlink" href="http://blog.citrix24.com/configure-sql-express-to-accept-remote-connections/">http://blog.citrix24.com/configure-sql- ... nnections/</a>

    Your connection string looks ok

    You may ignore the firewall part oft he tutorial if you you are working locally.