Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save TMQrX/567655a79518d21007a43a2eee6c37b6 to your computer and use it in GitHub Desktop.

Select an option

Save TMQrX/567655a79518d21007a43a2eee6c37b6 to your computer and use it in GitHub Desktop.

Revisions

  1. @testanull testanull revised this gist Apr 3, 2025. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Microsoft SharePoint setup guide.md
    Original file line number Diff line number Diff line change
    @@ -46,7 +46,7 @@ SharePoint version: 2019 (https://www.microsoft.com/en-us/download/details.aspx?
    - Enterprise trial product key: M692G-8N2JP-GG8B2-2W2P7-YY7J6
    - Standard trial product key: F2DPD-HPNPV-WHKMK-G7C38-2G22J
    - After setting up, reboot server
    - [x] Run SharePoint Products Configuration Wizard
    - [ ] Run SharePoint Products Configuration Wizard
    - [ ] Create a new server farm
    - [ ] In Specify Configuration Database Settings:
    - Database server: the sqlserver address
  2. @testanull testanull revised this gist Apr 3, 2025. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Microsoft SharePoint setup guide.md
    Original file line number Diff line number Diff line change
    @@ -46,7 +46,7 @@ SharePoint version: 2019 (https://www.microsoft.com/en-us/download/details.aspx?
    - Enterprise trial product key: M692G-8N2JP-GG8B2-2W2P7-YY7J6
    - Standard trial product key: F2DPD-HPNPV-WHKMK-G7C38-2G22J
    - After setting up, reboot server
    - [ ] Run SharePoint Products Configuration Wizard
    - [x] Run SharePoint Products Configuration Wizard
    - [ ] Create a new server farm
    - [ ] In Specify Configuration Database Settings:
    - Database server: the sqlserver address
  3. @testanull testanull created this gist Apr 3, 2025.
    76 changes: 76 additions & 0 deletions Microsoft SharePoint setup guide.md
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,76 @@
    Follow by MS guide:
    - https://learn.microsoft.com/en-us/sharepoint/install/install-sharepoint-server-2016-on-one-server
    - https://learn.microsoft.com/en-us/sharepoint/install/account-permissions-and-security-settings-in-sharepoint-server-2016
    ## Server setup check list
    - Server OS: Windows Server 2022 Datacenter Evaluation
    - [ ] Update windows
    - [ ] Rename computer
    - [ ] Config DNS before join Domain
    - [ ] Domain DNS server, example: 192.168.133.134
    - [ ] Public DNS server, example: 8.8.8.8


    ## Domain Controller setup
    - [ ] Add domain user (follow strictly by MS guide: https://learn.microsoft.com/en-us/sharepoint/install/account-permissions-and-security-settings-in-sharepoint-server-2016)
    - [ ] A farm admin account, with local administrators permission **on each farm server**
    - This account must have `securityadmin` and `dbcreator` on SQL Server
    - Use this account to perform sharepoint setup
    - [ ] A farm services account: a normal domain user
    - [ ] A sql services account: a normal domain user

    ## SQL Server setup
    SQL Server version: SQL Server 2019 Express (https://www.microsoft.com/en-us/download/details.aspx?id=101064)
    - [ ] Join domain
    - [ ] Use local administrator account to setup SQL Server
    - [ ] SQL Server Setup
    - [ ] Firewall open port 1433
    - `netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT`
    - [ ] In Feature Selection: uncheck "Machine Learning Services ..."
    - [ ] In Server Configuration > Service Accounts: with "SQL Server Database Engine" section, use a domain user instead of local account
    - [ ] SQL Server Management Studio (https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver16)
    - [ ] In Security > Logins: Add new entry with login name is the farm admin account with Server Roles: `securityadmin` and `dbcreator`
    - [ ] Right click on current SQL Server instance > Properties > Advanced, change `Max Degree of Parallelism` to `1`
    - [ ] SQL Server 2019 Configuration Manager:
    - [ ] SQL Server Network Configuration > Protocols for `<instance>` > TCP/IP: change `Enabled` to `Yes`. Switch to tab IP Addresses, in IPAll > TCP Dynamic Ports: remove `0` value, change TCP Port to `1433`.
    - [ ] Restart service

    ## Microsoft Sharepoint setup
    SharePoint version: 2019 (https://www.microsoft.com/en-us/download/details.aspx?id=57462)
    - [ ] Join domain
    - [ ] Login as farm admin to begin setup
    - [ ] Run "Computer Management" as local admin, add farm admin to local administrators group
    - [ ] Run `PrerequisiteInstaller.exe`
    - [ ] Run `setup.exe`
    The exploit works for both Standard and Enterprise editions of SharePoint, but we prefer the Enterprise edition for the demonstration. Please setup the target SharePoint server with `Single-Server Farm` role.
    - Key:
    - Enterprise trial product key: M692G-8N2JP-GG8B2-2W2P7-YY7J6
    - Standard trial product key: F2DPD-HPNPV-WHKMK-G7C38-2G22J
    - After setting up, reboot server
    - [ ] Run SharePoint Products Configuration Wizard
    - [ ] Create a new server farm
    - [ ] In Specify Configuration Database Settings:
    - Database server: the sqlserver address
    - Username: use the `farm service` account
    - [ ] In Specify Server Role: use Single Server Farm
    - [ ] Initial Farm Configuration Wizard

    After setting up with SharePoint Products Configuration Wizard, use the `Initial Farm Configuration Wizard` to continue setting up the target SharePoint server.
    - For the Service Applications and Services setup page:
    - In Service Account section, you can either use an existing managed account, or create a new one if you want.
    - In Service Applications and Services section, make sure the `User Profile Service` is selected for installing.

    - For the Create Site Collection step:
    - Enter title and description for new site.
    - In Web Site Address section: choose the root "/" path for the URL (default).

    After the `Initial Farm Configuration Wizard` has completed the setup, a new SharePoint site will be created.
    To check that the SharePoint server has been configured correctly:
    - Visit the SharePoint site URL,
    - Login to SharePoint site, **if the home page is shown, then the setup is done**.


    Apply latest security patch for target sharepoint server

    ***Note***:
    - After setting up, at least one SharePoint user needs to be logged in to initialize the User Profile Database.
    - Take snapshot of both `SQL Server` and `SharePoint Server` after the setup is done