Improve documentation about SQL Server installation

[MaiklT]

Description of documentation change

The documentation about installing SQL Server is good for developing purposes, but leaves a lot of "best practices" regarding performance and security issues.

Different use cases should also be considered:

• SQL Server on same machine as web server or not
• Machine(s) is (are) domain members or not
• Installation inside a DMZ
• etc.

Existing documentation URL

Setting Up / DNNSet Up SQL on GitHub Install and Setup SQL on DNNDocs

Existing documentation section (if applicable)

Whole page

Proposed area for new documentation (if applicable)

Whole page

[dnndev]

Thanks for the suggestion @MaiklT ! It sounds like you have some great ideas and suggestions. Would you be able to create this topic?

[MaiklT]

I have already started to do this, but it will last a while and it affects other topics as well (Security, IIS configuration...) My first thoughts about this were propably too much, I think that companies that run DNN as an intranet solution or implementing web farms have their infrastructure guys that may setup SQL and web servers according to their security policies and needs (incl. Always On, Active Directory and so on). Therefore I will not touch these scenarios, step back a bit and describe a best practice setup for these two (which are not too different, only in some points),and which covers the DMZ setup as well:

1. IIS and SQL Server on one machine
2. IIS and SQL Server on two different machines

To have it said: these are not my ideas and suggestions, but documented best practice.