I would like to allow for scaling of our RDS databases for an application but can't seem to find any information on how to keep multiple RDS databases in sync with the same data. Any ideas how to set up such a configuration?
Home
/
user-79862
Rob's questions
Hey guys, I've recently been having problems with Microsoft Server 2008, Plesk, and MSSQL. The problem was that when one of my applications in the pool tried to access the database I got an error saying it doesn't have access.
I have now fixed this problem by setting the application pool's identity in IIS to "local system", but I understand there can be some security risks with this. Do you guys have an idea for a better solution? One where the pool can access the MSSQL database, but not compromise security?
Thank you!