Can only create BLOGs in SQL from one web server

Topics: Business Logic Layer, Controls
May 8, 2014 at 10:48 AM
I have multiple web server, each with a copy of Blog Engine all talking to a single SQL server, however, only one web server can create the BLOGS in the SQL database, all other web servers appear to update pages and comments etc, but then, depending on which web server you access, the blogs pages and comments can vary, is there restriction in the Blogengine application when accessing a SQL Datbase
May 8, 2014 at 2:53 PM
BE does not work with web farms out of the box, here is post that might help although it uses older version and some things changed since then.
May 14, 2014 at 8:43 AM
thank you for the information, however it does not resolve the issue when using a SQL database, it appears blog engine will only allow one version of itself to talk to the SQL server, if you have multiple version of Blogengine running on say 4 servers, 1 server can access the SQL, the other 3 can read but not write, even if you stopped the server that can read and write on the SQL server, restart the other 3 , they still can not write to the SQL server even though they all use the same SQL login script, same user Id, same password and same database, read yes , but not write, yet the SQL user id etc, can do everthing, any other ideas welcomed.