I have 2 Windows 2008 Servers. One is a web server (IIS7). The other is a database server (SQL Server 2008). The instance of sql server 2008 is configured to use mixed mode authentication. Neither are joined to an active directory domain.
How should ASP.NET applications on the web server login to the databases on the database server? I have tested with the SA account, but obviously I need to change that.
I am confused about what to use: sql server account, windows accounts configured on each machine, or "Application Roles," which I don't really have a great understanding of.
The account just needs to be able to read and write data, and execute stored procedures. What should I do and how do I set it up?
Instead of just a quick answer, please give me instructions on how to set this up. Thanks.