Windows Server 2016 running IIS and SQL Server: configuration topology and optimization – recommendations
Posted on 2016-11-03
I am in the process of setting up a 2-servers home-based network to run IIS and SQL Server. It is my understanding that is best to use one server for SQL and the other one for IIS. I will appreciate your can share you recommendation in setting this up in order to secure and optimize performance in both servers. For example, should I setup the servers as Domain or just as Workgroup? What's the best practice to secure the two systems? I know each topic can get *very* deep and can have many variable, so please think on my environment. Both, SQL and IIS will not run anything fancy (heavy). I know Server 2016 is new and I am aware of the existence of the nano-server option, however, will prefer to use a traditional interface (GUI). Thank you much!!!