SharePoint: Guide to Install Three Server Farm using AutpSPInstaller

Article
1/17/2024

This article will be divided to three sections

Setting up the Environment and Service Accounts

Download

AutoSPInstaller Online is one of a great project that facilitate Automated SharePoint installation including Sharepoint 2010, 2013 and 2016.

Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm.

Reference: https://autospinstaller.com/

Servers

Before doing anything we will set up the environment for SharePoint three server Farm.

Will name these servers as

SPWFE - Share Point Front End Server
SPAPP - Share Point App server
SPDB - DB server

Environment

https://lh3.googleusercontent.com/DmVfFhcGOcbp_68bXo96iCLlHqNuIwhLCgBFXTWiPQFjWh6qN38Qyn7TU88BeuRWFU8TrnbKr6C93ys60aO11N0l4Wmye2ABTd5KsmAIg9H9Mh6ePSdtawGkDudbp0R-BjfsXEFv3M7kQkSDzz0px4fv3U335goJOg0RKPc7iMcgWsDvKBy0IYgndCKZ5_CXFZuh8cUx5WG91gfCwwgcJbai_VntpM7kIifHPworpwyaE9sENWCJjQkimLsqM-6xvKr50rOMmYBZAvkk7CwMeXfn4z67BGFnkaR9xt70L3UY9Ad5WZeDHDhqnIbzZXiULbS3STtJ2lqsx9eZ_zPJASS5eL__Ezs9-sxcHRnrBGp8NQLPLm_PAJSTN2cNTQp8a9V2kdECbZ7ZRM2VpSlOTL7zBjleomMJrjFWUPaiAXpFmG3OnTXMsSBOTJcZtf84qh0_9EBMUJeT5Iktc7NN_parmTOsyC-vgMrOQ-a-SjPg9GDRgLsSMiOUZ2OQ6HKDdUeLSINeb8Ib9QN4LOhv3NdhEfvj9KF_q8_IcpJSdcJob1DP6G2QxZEgFeIfmX6JBDGIuY7EDW4v6gxoutndSUDfh5kvJOFz0bZbDn60bXRxm2sQOHgeW-r5zg7EKkiq1641z0cwETQWQHuXcICaERPVpqIKWhO9rnTBvhCp9q3ojZi2MC1THzNKcU3b2TKx4crNeDlilr-tM3lo3Aqi7qTK-A=w461-h121-no

Minimum requirements

Please find the reference for SharePoint minimum requirement and practices from

/en-us/SharePoint/install/install-sharepoint-server-2016-across-multiple-servers

Service accounts

For the the medium segregation, we have to create below list of service accounts.

Service Accounts for Active Directory

Service Account name : spadmin

Rights : Local Admin All Servers (DB,WFE,APP)
SQL DB Rights: SQL DB Creator and Security Admin Rights
Domain Privileges: Service User
Description: Use for set up and Configuration

Service Account name : spfarm

Domain Privileges: Service User
Description: sp timer service , Central Admin Application Pool, Other Configurations

Service Account name : spservices

Domain Privileges: Service User
Description:Service and Pool account user

Service Account name : spsqlservice

Domain Privileges: Service User
Description:Run services in SQL Server (MSSQLSERVER, SQLSERVERAGENT)

Service Account name : spsearch

Domain Privileges: Service User
Description: SP search service , crawlers , search related

Service Account name : spprofile

Domain Privileges: Need Replicating Directory Changes
Description:user profile synchronization account

User Profile User Configuration

Run dsa.msc in Run Windows or open Active Directory Users and Computers.

https://lh3.googleusercontent.com/EtgWXpR-MzavPrRJNFg41GO1KIecEwwT_QDwf-6VR4GQBSVgQp97YpVqyU1P3gDsQ68fyOCLUErxEhSJCSt5m4zpyP3gTVs-5etdMh1YZkmmIoCbj8C99wxrOkixoDgzTc9S9IUWl8LQhHGwGWUOJ1LxH3RNabr1WodpNg4x4l8-OUPyEjDUellfOoBrXJsZ7q38M1NBcVtbH2RdM3xiSAg4qKPiRhgT9UjfIrP78ehDkl1yGYaa3qYixGKqfG51vWKN7t3y6Yw6c4pyeMG-lbiBD6gANOF0mf24GKFMJJGsnzhQCLmHA1ffQt2uX63JajxuyMEWxEi3R-7aCq98isWa5gR1SK73Uazt5jIg8umyKa1eJKBtCjaBrMZCDxDeiSyplfvgR2EYtgYtPHpw014tFZiOtiTCfb9Rq8yl5ImwpEVRZtbja-EWfg7eZ37WLoVspNCrWJWTTMhFFA18ZMtBxNmaojrIapLcIZD_xLtUQ9iCAky_B11p5uP5S_4VQYdBoh1BtVxfobvjdBqLcUUMRWaoSagXFP4h9VcTPHjxKkR1uUTvD8sVL7tUZXC046JFTTCWS8mkrSL1cRjz8l--CeY29jUyoIIYLERnwnhTH73CJy10BZ3Ci_D8ZEhJdTYSmlR5O6ryQDrq0OfNOUimN6nxX8BdGpJXOEtJlsdz2RSuEVuIIIwBiPEVUYQnCANk1ZF1tGsxhRDXmFsoIdErmA=w604-h379-no

Then Right click the domain and click delegate control.

https://lh3.googleusercontent.com/uBTzt0QdrQ-E-AeAUNfISkfniiG5dSiY5BnHHVBBENTWDeBHy8FdpqmXVb95C_sF7dUPduyoYD3zOUSmucVrIGl3SyQxzeqm6G0i2a_mPMv6U-dTbQkOhmVjR5lpspL7Y9pwVERF9sWbKQ4nTQdtj8M7m6sI5TYQsp5uANkG-uVrMuXNlL6t5yatp0dm30uKUM2S3TgOsQk-Dh_Mwx1U6v4K4kHBeIs_9Te8hgiPvDTj3WeWdbHaFb528Wod3UtQiBPL4xcJtNDRI1S5P8ZbQ0oIsTPj6UEV5_whjeW9CRnCjF97JnEvzPTpKqM12htZ16KALGDxgAi6NoWK3WJIqN103Pnyn2ylFGYm2-N8ETccEn4AXXxOkccJ0GF7Cc0A-vMC3ePNnMW1x76fw5E4yCTNJT8fJ3E_t_OpYPTTkwPHJ9Xe5THCjiA50UPQolRtxOwVAN1y8vsypgDWnt7i_oRQz-9ZiHsO8pN2US88gm1y7Zbse-nT7OG2Tqfrif5s8BhLE1iSlkM5S6QhXtaeiFK3ypSc411Mf9XDVmUe18SK2k1lL8f9iTcYOX45F9Bk8NNHKNJs1nBtZRZkWyLwMXTVfib9NOMBpaFSUWXcdVSTXOAThDFbM5JNOZfPseO8mmPqg_smxBOj_aw6BgDAPWbmDlIL2iUHQw_nOr91axDQcSzU8Thrn8GaiRCjw2amT3xMSNsYE_8Xw4ZfErqlbBpkcQ=w333-h109-no

Then click next and select spprofile user.

https://lh3.googleusercontent.com/oq8kAPXSuqu-Yfg450bSHMrVX_3hBhY7e58hM7zd4m0M9i7vFg48hCdNY6ow5IpR6DRoxZ00JQ0i0FMIdVVzx3jOFJqd7dy6xSwwprZX9OQwbq0D2_t_CAQMICzOjynqAuYQMp1n4QNXvcFLy9BM5WzQ9yTBjDSATTLZ16WybX43py5EEEDa68fYSgsRnb-KEpG32mgWVof1TWh7pbaeK79uaPSSogM3oKs6aIJ2fJflAHAvLtn2S4uXF_9nJZBX-156rebLMyoAWoRDQIppSBWsBWST2QE90U-IxGHCeOCBzWNZm__5YdE2zQqLDT8uWqZolmSyutZYhrz4ZDxx-4WX-zLCHjf_S7EQrVKmiE9O7_o6RZx3LoPomZZK7mvKJJ6GPoeVQ-ahAqHb4awJmc7JLY4Fb7EO8LxLyXlSmqcUCwv7ZCOJs1yuA6UhnImyTyhnUcCgJXe-AN-Us3XhWqh7YLKt_E6rbD8NV46lqsTlNh6OlJf8dS8FLsFwcSyr3kMdilzZeNyYkWmExGAXLKPBVul40DtOmpjIz7XLNAgPaCQ96gBLWtqtfruj2gdo_syhQShrB6jCY68hAXah-EIdLl2-zaLzrgz8ZggCKRC17z1mEfekv5aCe-iKBfDIFW_LI0ae-0dXQZHKCFLzS6Pqoz8REEC321zLdOTvqrXHDQWqbzKZy6NfTFRMJ1jvAN7CpU9WWlRYErtpG96Z70fPcQ=w431-h344-no

Then Click next and Select Custom Task Delegate and click next.

Then select This folder, Existing objects in this folder, and creation of new objects in this folder and click next.

In here select Replicating Directory Changes and Proceed to finish the wizard.

Configure SQL server

After installing SQL server you need to do following configuration. also you might need to install .NET 3.5 manually in the server by specifying source path manually.

Setting Up DB Server (Login as spadmin)

I installed Windows Server 2012 in the DB server. After installing OS you need to install the SQL server. Following are the steps you need to perform additionally.

In the feature selection you can select Database Services and Management Tools – Basic , Management Tools – Complete , Other than these features you can select other related ones if needed.

Then You can add spadmin as a Admistrator for management.

And you should add spsqlservice as service accounts running credentials for MSSQLSERVER, SQLSERVERAGENT.

Then complete the installation and** Enable TCP/IP** , and** start the SQL browser** in SQL configuration management.

https://lh3.googleusercontent.com/PqoYor3T3PQqjGXBsCHwsSHPIzgtoGTkZkCiqfzqJ4butMCAyLo8MbfP5asdiIuG3N9IXXLjj4gtSf34t4JirgfF1uVOoZimhmPF4-RWIJrZfxdYEBEuzQ1vtw1ShL_p2-8_nQHbSRWFV8911AITsqI6Z-6C4BILY4HP8XKEwR35udIuT2kBNiSc_74RKKjMOR7I8K0qQK9hsbPOy2GFITa1Xf5aAaGXHIp6-vWtq4hPayyXbGsIoZNtVQE8aELLc39BXdcM0U9DQ8oxBG4dBzfcrKXKC7Gw_x84MUJ46FfUHJd-sGaYZhicSQaYYMsHw0M2ayjqszmgIZ-9v8frG_76MW8aZj2tuscRlHqNib4QRCCxxGbWp4FfVe8pyDWhMkD84wjsw7fqlBqTbN1SLs-d5cbZ8cwpB0dJQpZ5tRRqTMqL6rEiJOoAbDRgnr5yHbvWxXsNw_ugA1gVtkRV0KBQV41Rdf_-Y9DpLBYvZOydj8xmqErynsBzxp9_SIy2mraVFN-duEscQG6YEeV9mT4Zl6TgZ4rigKFXG7vHV5uZobAZzWWAScQ5MAduR7b44EVAGg0EgOFAbmoMTmTe7P4LoQ7KyCMjGtQVJyZKF-L8eE-S2kosGInR-G7yMIU92Y5sKHyEQxAQwaG675mTbRqbKYcMZpvIXkn2MiVMx4-jPcEjPVHXb1DpwNCTVv8nkacxdLQUsR2FTS4mLB-PM2l3-Q=w493-h172-no

https://lh3.googleusercontent.com/CCwwPnw0VaQ6RRbVkYs4hXMbLlc89RUZdMFiob3VP32tYp6GwSxzo3rZJTxSEqcLO_9xWWtjToKu1mY47gAAFA79QiMSwCUerZd0CbRkSe09GOi2UaMZ10vm7QUU20-FXsoWUzR4403WX1Leyq01es1tRFpH9Md4zqf_LeG1PrdpekbBS2twjU4xon2eJrsDuFRyqWiKjoEeUSaPyzPeJaBP-FWCGuBSpCr5vLHqtdK3p8RFt-6JiU1Lt_5RCQC_p8Om6nAH6rnG3xJ9MtQZ9LM3JyO0ej3O-pL0kzdXl3Zxy_OI2NlU9uF41NcngxVOq7Wm6qnSxL4T2b_K7VS_CSJz-4ASmam-dC511PKiGn3mFSvvlBm8spvyATixPtrkO29E7rY0YUmsrj8URp9u0MWSmIKKZbX6k7GiTUJiFgL-RDEw1ilf-Xj64PC45K0VqVP_SI_vJBU2nP1f4HmVQ-HS90i_mXlA9P5Buyu3abuoxkol0YU6J4BSTtRA6DnAFtg1ssxKTHhIoqCqlUbhd76UXCwQ7wYID33FM2C-OA-e1uqMsNxvaOOjMy5evrp9flfBJOvuEM_T1G-_8e_SZeowRuNPKfrv4EbDxEWiYZivib98QHBNB3xyDsqyRLU7yKz45pQ_8ayCG2R59hEFGsk40-lpv49WfNnS2sGGZvLPd1qvO86JczcrwVhdYChH5QTqnxNCoWIoxhXI-GgsHYR_7Q=w429-h247-no

Getting Ready with AutoSPInstaller Online

First, download the latest build from below link: https://autospinstaller.com/Download

https://lh3.googleusercontent.com/-tKIu_sLnXRrDF7K-wldLBpiHJt36dPB7gDvSKYWQ0U0Zo4v8HB8oMUOxMjrHWbWzaCrYeYjht_dl5hbeec7CAd5BAzCP1IqYwCYrwSHghWxDghb5-x8asSVOK_15qbqTI6XGS9j0ethNezJyfXWTDursyjFCbUkZCfCguKsqr1xFrk4W-ATdhJ2eWKkqB7f3H7pK_9C33kxJh2FPgPrn1BtLle2SIj7cC6Owprfn8SpYl6cDsFxo4gtedLiN1RW0PlxDbMi4aCMRcENrDUD4BoKWUNcTd3cRYuxvNBFZkCCO2pZEZUYBTHC1z73zUBJ9te-L9pmj4FS0oXLSx7CshgrsGVz7B102idQQx_6oQa1ybA51a4iLtnI3-YyHoHA-2o5aTVDaJ8VrVUqC1lsXRClbgKyT8nzoKf1-xz63G95mEnJbfbva_MRKFLNY_PaaAgFfsp_jQmJc8FgGrYWX_0MwRsMhIidZjNaFgWhl0PYSIzxEeWm8hxNK0LP9jdwyv-Az_jBUGVv6odCZ6uNvwyna-0cEUPacgDR3J8fhCVgTd7HMSLVcF8lU_vOZnehYRTCMYIFamjNCi-qk7H3uzzD88WxORx2gmPHF2-GVWWlz7Hd53Xd3kaUTKpnz1hVT1FLTVqGF22xQm0-_5Q7DGOUPfggeP_WBfFZ6BSHMl4IqS95Nbel1gkeHeNvBeCefVaDhVlIqiclLASX-c7wfAY65A=w993-h314-no

and copy, SP folder to C:\ drive (this can be any convenient location)

https://lh3.googleusercontent.com/Zd3JtKRoV5bT_TafjdGeQ6D0kyUeYct-L9kJ4nI8vpfJO4sw2XU-L9nXxcOcu7bBfZJ7jqkn08W3IJ3-rxppEo0BNindEtotdy_ZgivB2zfP7niOHGyu0pQYmnjXLBFmu5n11DpNV0fBrNbafrfPmwG5bZM1xre4a1qlcrn5vurzjJxkTi6PxXT8J8bxab35D5ODafdnau-2Un-IndIF12CGmfifHvXNvT0OH6jBI-AEOcBYS_IuS6lbWmIf-5mYcir-wpalIPfAWXdUK42HCCzbxmLGtTrK63Mb4kby9oA2pwFZRIBm85FKMwodwqOTPyBK6QKPGkIJphvJYSLEIYtv-cMkig5EAz4MlAxPpd53uOd-EWSdy4g1YJykI6Bl78gqeBb9ht0t38rKNM78qwmZoMTTHWbsFOLEHjxFeAOkb7Irfg4WVov3sPRVJgWfwaBZv84XRy8Pde5awOVQNRmxBmjq_DKsoduWI7LVRfEs-3FSIyJCtN-c262BFyE643MzL1tdipAU0yayDKk7spDprRfhTQD6imPo0Y1PyhrYrimsVqiDbDV9bfRMCgyrQAEJAhCxpFHegq2vZKjGuduS-MHfBuDswIC1OE-DemjMFIZSb8G5XV0gZcGwXXWb5RhFGNlFI4TvVA61cIsaxhCzE_3GLe9gNUGZulmt6L5aiPaFSS-AqpcGysFT1EXn6xPTB-8OHGkmN3FcRzIHuZz54A=w163-h214-no

Now you need to mount your SharePoint Image and copy all the content to inside the folder

2016 –> SharePoint

then download the prerequisites files from as required

Download prerequisites

SQL Microsoft SQL Server 2012 Native Client: http//www.microsoft.com/en-us/download/details.aspx?id=29065
Microsoft ODBC Driver 11 for SQL Server: http//www.microsoft.com/en-us/download/details.aspx?id=36434
Microsoft Sync Framework Runtime v1.0 SP1 (x64): http//www.microsoft.com/en-us/download/details.aspx?id=17616
Windows Server AppFabric 1.1: http//www.microsoft.com/en-us/download/details.aspx?id=27115
Microsoft AppFabric 1.1 for Windows Server (KB2671763): http//support.microsoft.com/en-us/kb/2671763
Microsoft Identity Extensions: http//go.microsoft.com/fwlink/?LinkID=252368
Microsoft Information Protection and Control Client: http//go.microsoft.com/fwlink/?LinkID=528177
Microsoft WCF Data Services 5.0: http//www.microsoft.com/en-us/download/details.aspx?id=29306
Microsoft WCF Data Services 5.6: https//www.microsoft.com/en-us/download/details.aspx?id=39373
Microsoft .NET Framework 4.5.2: http//support.microsoft.com/en-us/kb/2934520
Microsoft .NET Framework to disable RC4 in Transport Layer Security (KB2898850): http//www.microsoft.com/en-us/download/details.aspx?id=42883
Visual C++ Redistributable Package for Visual Studio 2013: http//www.microsoft.com/en-us/download/details.aspx?id=40784

and copy under the prerequisites folder inside the SharePoint 2016.

Server Set UP Servers

You need to install following pre software in Servers in order to Set Up SharePoint.

Application server Server, Web Front End Server

OS: Windows Server 2016

You might need to install l .NET Framework 3.5 to the server.

Thus you need to install manually.

Ref: http://www.danielclasson.com/install-net-framework-35-server-2012/ Jump

http://en.community.dell.com/techcenter/os-applications/w/wiki/4146.installing-net-3-5-framework-on-microsoft-windows-server-2012.aspx Jump

DB Server

OS : Windows Server 2016

SQL Server 2017

After you install the basic required Software and Operating system now you are ready for install the SharePoint.

Before, installing the SharePoint you must configure the AutoSPinstallerInput file.

https://lh3.googleusercontent.com/xwl9DZW1SsLc0J7Rui7rzAczO_ZCZwQHFXuR60DaZpeqchsZpg1Fo7VAR99_VoiQ0mDDW6biJlaqeq9rmZ49HlLHDJINy-Fkd4uV45a5nrYPWofSh-rPt_P6aTrIFywP0ZjiLoPc_ViCfhNvqf1XX8RvEAIo-OgLS7H1fLgzX7f8jWvbKAkomeYSTBsuTDehAThjm1evRF8G4FlMpjqxDXemtjG7K1gs6MdNNafEfAId-nRqL9-wOXfhiiXWRqfi7SdvnckjbT4W4xrwszGjJomusUKFCY1JKrOoiRUCi6vkB01tBDn40NvZ9XF5VPqg1GnATVbK3K6MuGwoOKqpmZOYcBiRBMe8vm8msth6rQ9gTgv5QbgSojQAzZIeMK1rOx_NN_q9hS8Xzl3Z8lhAxnjLXDGnXQwe1sNoAYJDLdx-xE-yqa2YOG6LC3KUWLld3OODnNFA5VT1svR3h-SPFXph9MAnSKF1DJvP4jsWwzlhQuPHgZmgRj1UgyJC_4HTzsLICIhZlNqtCPexr5ai0nZca6f555n1jgkHDWd_pW_iJewUDa6eZe_kHaD2XWDPUztr67gsBvGBfP9bBKR4PbudPqowZrNgUbz5_7zacQYKpeo6Mv71UEoO0QsqG8GZmdYOM0jQp4JtDDe2oipC5Bi9K9ySW3fJ0izxMg6qJKubKX746M4AoiHflwbaxOY5zrXcpUyjAvQpUxntftH5ji2QOA=w274-h72-no

This is just a XML file , you can Edit using NotePad ++, but there is a great online tool provided by AutoSPInstaller Online, that you can use to configure the XML file.

https://autospinstaller.com/FarmConfiguration

https://lh3.googleusercontent.com/uA7Fcy7b3RYPhwep8aagJ186OM_Hn3Z618jdfUtd4zt89PmGPwLitk6iL9mj8lOasCnCxxbrgTf7nMtUo7Es0dtgjOrLAHsKKVDHF7sdHLm37K84hrG6OoVbkeYNjGqMfzQSE52pEYfQFZNuNd0dVhWp38xeUCqzRm8HKOEEfpOJCOScX9q2Yn2nqEyHpBlHgFQjAJgaZIKJ7p-KKphleJaTXn02Odn665tZq63IjzcCRpa1VHKF-UnPQlBQx_xqM8SjV7wJgmLhzpmmMID_h9hoyVXQf5PQN9Vp676HNuqM7CKaIsqGDu-INmZS3TgbbAeoxo9bI7BNJawj2Ji_iBQdIKZqx3c3Lpq8pAU3ydtFQfWDzHFErl0d6LRAXCCNYDPwMWQXwrXir9KSGeYN_ORLRJlPjUHK2ZbHXaz3bVZIUAK2n61zb1CgB1tvipkKMFXLLN6jeYOeCgqNt0M8KSROo2gCQsv1VjVz6zemf_a9nkcSfOBcZ8ii9syl46mrTDq5uYJKGFxMsrXub1b2t3v4XSAlOYCeDCESISAMyCqHizLNSFGmeQRIOlanRzLRhG6Xf2vp_ZU1b3bGBHirZYQL3dl4qs-buJ_1pq1HRUm_NCWprIvI1AoJtXlMtRJzexvhvp1_QSibcf8dcNd9lw3nLftoBIAd7-wNFML9UrNVmXZu39wBopcHwSpEE1flAvcnlI9h1JTpym69N8OZ1erS3w=w1026-h397-no

You can load the XML and enter your service account details and DB connection details and save the file for installation.