How can I organize a secured environment with different requirements like deploying webpage to web server, SQL authentication via windows rather than SQL server user etc?
Hello Josephine,
First, you need to consider how to protect those files when setting up your server, ideally your database server should be a dedicated server. Setting up a development environment, you should bypass all three of the potential system accounts and instead create a user account on the domain or local system. You need to think over regarding the logical location of the server and database files on your network.
You might need this link to provide you more specific solution to organize your secured server, https://technet.microsoft.com/en-us/library/cc966507.aspx. I hope this answer might help you.Incase you need more assistance, just let me know.
