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