Same site multiple instances with one DB

Dears,

We have a site developed using NopCommerce, we copied exactly same site on 3 different servers for load balancer.
But we dont want to have 3 different databases, there is setting.txt file which hold connection string for SQL server, even if we change this to point to main DB server, it dosen't work.

Our 3 same sites are on differnt VM;s and on same network.Using SSMS we can connect to main DB easily.
Please advise if we need to do some other step in nop commerce configuration.

Thanks

what is your version of sqlserver?

do you have

Encrypt=True; TrustServerCertificate=True;

in your nop connection string?

There is a store setting in nopCommerce which is always going to throw error in your administration area as it looks for set domain in the setting with the domain that is being used while visiting the site.

If you are using same database with 3 sites, you may see this issue.

You can experience the issue if you enable SSL on your site.

Question: Have you considered multi-store?

Dears,

Yes connection string is OK now, i have 3 servers, 106,107,108.
106 is main server with NopCommerce and DB server. Other 2 have only application.
I was doing mistake in connection string and application identity user.

1. In 106 DB added a new user with SQL server authentication
2. Added local user on 106,107,108, and gave IIS privileges/admin, assigned this as identity for application pool
3. Now added connection string like below in each application setting.txt file

DataProvider: sqlserver
DataConnectionString: Data Source=106\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True;User ID=106\appstore;Password=123456;MultipleActiveResultSets=True

Thanks