SharePoint Server 2016: Secure Store Service

In recent series of blog posts, I shared detail on Installation and configuration of SharePoint 2016 and also for WFEs. In this blog I am sharing the details on how to provision Secure Store Service Application in SharePoint, follow below steps the provision the service.

  • Create service application through SharePoint 2016 Central Administration. Go to Application Management >> Manage Service Applications >> New >> click Secure Store Service Application.

SharePoint 2016 Secure Store Service

  • Enter Secure Store Service Application as Service Application Name, SQL alias for Database Server, SP_SecureStoreService as Database Name and Windows authentication as Database authentication.
  • Enter Application pool details, select Use existing application pool dropdown and select SharePoint Web Services Default.
  • In Enable Audit section, leave it default.
  • Click OK to create Secure Store Service Application.

Useful links:

SharePoint Server 2016: Setup outgoing email

In current series of blog posts, I shared detail on Installation and configuration of SharePoint 2016 and also for WFEs. In this blog I am sharing the details on how to setup outgoing email, follow the below steps to configure outgoing email in SharePoint Server 2016 (similar steps for SharePoint Server 2013)

  • If you have existing SMTP server, you can configure with the SharePoint Central Admin
  • If not, install a SMTP server as your outbound SMTP server.
  • Configure the Outgoing e-mail server information by opening SharePoint Central Administration and following these steps:
  • In Central Administration, click System Settings.
  • On the System Settings page, in the E-Mail and Text Messages (SMS) section, click Configure outgoing e-mail settings.
  • On the Outgoing E-Mail Settings page, in the Mail Settingssection, type the SMTP server name for outgoing e-mail (e.g. “mail.MSTechTalk.com”) in the Outbound SMTP server
  • In the From addressbox, type the e-mail address as you want it to be displayed to e-mail recipients, such as “sharepoint@MSTechTalk.com”
  • In theReply-to address box, type the e-mail address to which you want e-mail recipients to reply to, if desired.
  • In the Character setlist, select the character set that is appropriate for your language.

Click OK.

SharePoint Email configuration

Test outgoing email by dropping a test file in the Pickup folder https://support.microsoft.com/en-us/kb/297700

Useful links:

SharePoint Server 2016: Configure Usage and Health Service

In previous blog posts, I shared detail on Installation and configuration of SharePoint 2016 and also for WFEs. In this blog I am sharing the details on how to manually provision Usage and Health Service using PowerShell.

Provision the SharePoint Usage and Health Data Collection service application in order to name the database according to the preferred naming convention.

Useful links:

SharePoint Server 2016: Configure State Service

In previous blog posts, I shared detail on Installation and configuration of SharePoint 2016 and also for WFEs. In this blog I am sharing the details on how to manually provision State Service Application using PowerShell.

Provision the SharePoint State service application in order to name the database according to the preferred naming convention.

 

Useful links:

SharePoint Server 2016: Add a web front end with distributed cache

Please follow the previous blog post to install SharePoint (SharePoint Server 2016 Installation Step by step) and running Configuration Wizard on Application server. Login to the Web Front end server(s).

You are now ready to run the SharePoint 2016 Products Configuration Wizard located on the Windows Start menu. Follow these steps to create a farm:

1- On the Welcome to SharePoint Products page, click Next.

SharePoint 2016 Product Configuration Wizard

2- In the dialog box that notifies you that some services might have to be restarted during configuration, click Yes.

SharePoint 2016 Product Configuration Wizard2

3- On the Connect to a server farm page, click on Connect to an existing farm, and then click Next.

SharePoint 2016 Configuration Wizard Connect Existing Farm

4- On the Specify Configuration Database Settings page, do the following:

  • In the Database server box, type the name of the computer that is running SQL Server.
  • Click Retrieve Database names and select the SharePoint database and Select Configuration Database. Click Next to continue.

SharePoint 2016 Configuration Wizard Database Settings

5- On the Specify Farm Security Settings page, type in the farm passphrase, this should be same as you have given during the application server configuration wizard.

SharePoint 2016 Product Configuration Wizard Passphrase

6- On the Specify a Server Role, click on “Web Front End with Distributed Cache” Click Next.

SharePoint 2016 Configuration Wizard Server Role WFE

7- Check all settings and Click Next

SharePoint 2016 Product Configuration Wizard Start

8- If you want to host Central Admin on this server as well click on Advanced and select this option.

SharePoint 2016 Product Configuration Wizard Advance Settings

9- On the Completing the SharePoint Products Configuration Wizard page, click Next.

10- On the Configuration Successful page, click Finish.

SharePoint 2016 Product Configuration Wizard Completed

11- The Central Administration website will open in a new browser window. On the Help Make SharePoint Better page, click No, I don’t wish to participate and then click OK.

12- On the Initial Farm Configuration Wizard page, click Cancel. As I mentioned in previous blog post, that I will share the details to manually configure the service applications, as I do not recommend to configure all service using Farm wizard.

SharePoint 2016 Configure SharePoint Farm

SharePoint 2016: Products Configuration Wizard

After Installation of SharePoint on all application and web front end servers as mentioned in SharePoint Server 2016 Installation Step by step, you need to stat the configuration wizard to create a new farm.

You are now ready to run the SharePoint 2016 Products Configuration Wizard located on the Windows Start menu. Follow these steps to create a farm:

1- On the Welcome to SharePoint Products page, click Next.

SharePoint 2016 Product Configuration Wizard

2- In the dialog box that notifies you that some services might have to be restarted during configuration, click Yes.

SharePoint 2016 Product Configuration Wizard2

3- On the Connect to a server farm page, click Create a new server farm, and then click Next.

SharePoint 2016 Configuration Wizard Connect Farm

4- On the Specify Configuration Database Settings page, do the following:

5- In the Database server box, type the name of the computer that is running SQL Server.

6- In the Database name box, type a name for your configuration database, or use the default database name.

SharePoint 2016 Configuration Wizard Database Settings

7- In the Username box, type the user name of the SharePoint farm account in DOMAIN\user name format.

8- In the Password box, type the service account’s (SPFarm) password and click on Next button.

9- On the Specify a Server Role, Click on “Application with Search”. You can also select single server Farm option if you want to deploy SharePoint 2016 on a single Farm. Similarly, you can select options under detected roles or can use Shared roles.

SharePoint 2016 Configuration Wizard Server Role

10- On the Specify Farm Security Settings page, type a passphrase,

Save this passphrase in a secure location, this information will be needed when adding/removing servers in addition to being the central encryption key for your SharePoint farm.

Although a passphrase resembles a password, it is usually longer to improve security. It is used to encrypt credentials of accounts that are registered in SharePoint 2016. Ensure that the passphrase contains at least eight characters and at least three of: uppercase letters; lowercase letters; numbers; non-alphabetic characters. Click Next button after entering Passphrase.

11- On the Configure SharePoint Central Administration Web Application page, do the following:

12- Select the Specify port number check box and type a number (of your choosing e.g. 8181, 1337 etc) as the port number for the SharePoint Central Administration web application. Select NTLM under security settings and press next button.

SharePoint 2016 Configuration Wizard Central Admin

13- On the Completing the SharePoint Products Configuration Wizard page, click Next.

SharePoint 2016 Product Configuration Wizard Start

14- Product configuration process can take some time to complete.

SharePoint 2016 Product Configuration Wizard in process

15- On the Configuration Successful page, click Finish.

SharePoint 2016 Product Configuration Wizard Completed

16- The Central Administration website will open in a new browser window. On the Help Make SharePoint Better page, click No, I don’t wish to participate and then click OK.

17- On the Initial Farm Configuration Wizard page, click Cancel. You can configure the services using Farm configuration wizard, I will show you how to manually configure the services in upcoming blog posts. It is also recommended to manually configure services in when you have more than one server for SharePoint (like app servers and WFEs).

SharePoint 2016 Configure SharePoint Farm

SharePoint Server 2016 Installation Step by step

In this blog post I will share the details on creation of Multi server SharePoint Farm which include the Application server and Web Front End servers. I prepared this post in a way that you can create single server to multi server SharePoint farm and can create Dev, QA or Production environment for SharePoint server with latest updates.

SharePoint Setup and Managed Service Accounts

User account details for SharePoint setup and Service accounts are listed in SharePoint Farm User Accounts.

Add .NET Windows Server Feature on SharePoint Servers

Make sure you have installed you added .NET windows feature on all SharePoint Servers, if not then follow Add .NET Windows Server Feature on Windows Server for details.

SQL Server installation

Make sure you have installed SQL Server on a separate machine, follow SQL Server 2012/R2/2014/2016 Installation Step by Step for details.

Pre-requisite Setup and Installation

Log into the SharePoint Application and Web front ends as the SPAdmin account. Check post for details on SharePoint Installation/Service accounts.

Pre-requisites must be setup/installed on all the Web servers and the Application servers.

Before you run the Microsoft SharePoint Products Preparation Tool, check for server updates on Microsoft Update and install any available updates to ensure the server and operating system is up-to-date.

Once you have finished applying the available updates and patches to the server, you are ready to run the Microsoft SharePoint Products Preparation Tool.

You need to install software prerequisites first before the installation of SharePoint Server 2016, the prerequisites installation can ask for restart multiple time. Start the prerequisites installation as shown below:

SharePoint 2016 Pre-requisite Installation

On next page, you can view the license agreement which you have to accept if you want install, you have to accept it as you having no other choice. Prerequisites installation will take some and will also ask for restart. After restart, re-run the installer file and run prerequisites, this will again ask for agree on terms. Again, continue it and wait for the installer to complete prerequisites.

SharePoint 2016 Product Preparation Tool

After completion, you can see the installation status. Installation status in my machine is listed below, all installed successfully except .NET framework.

  • Application Server Role, Web Server (IIS) Role: configured successfully
  • Microsoft SQL Server 2012 Native Client: was already installed (no action taken)
  • Microsoft ODBC Driver 11 for SQL Server: installed successfully
  • Microsoft Sync Framework Runtime v1.0 SP1 (x64): installed successfully
  • Windows Server AppFabric: installed successfully
  • Microsoft Identity Extensions: installed successfully
  • Microsoft Information Protection and Control Client 2.1: installed successfully
  • Microsoft WCF Data Services 5.6: installed successfully
  • Cumulative Update Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB2671763): installed successfully
  • Microsoft .NET Framework 4.5.2: was already installed (no action taken)
  • Update for Microsoft .NET Framework to disable RC4 in Transport Layer Security (KB2898850): installation error
  • Visual C++ Redistributable Package for Visual Studio 2013: installed successfully

SharePoint 2016 Pre-requisite Installation Completed

After installation, restart the machine and you are good to install SharePoint 2016.

Install SharePoint on all Web Front end and Application servers.

Log into the SharePoint Application and Web front ends as the SPAdmin account. User account details for SharePoint setup and Service accounts are listed in SharePoint Farm User Accounts.

Install SharePoint binaries on the Application Servers on the QA/Test environment and the Production Environment.

To start, logon to the server using the SharePoint Admin account. Running the install and configuration wizard under this account will ensure the process provision databases on SQL Server with the main SharePoint Admin account as the database DBO.

1- Run the SharePoint setup media.

2- On the SharePoint Start page, click Install SharePoint Server.

SharePoint 2016 Installation

3- On the Enter Your Product Key tab, enter your product key, and then click Continue.

SharePoint 2016 Product Key

4- On the Read the Microsoft Software License Terms tab, review the terms, select the “I accept the terms of this agreement” check box, and then click Continue.

SharePoint 2016 License Terms

5- On the File Location tab, change the installation path to the secondary drive, and then click Install Now.

SharePoint 2016 Installation File Location

SharePoint 2016 Installation in Process

6- When the Setup program is finished, a dialog box prompts you to complete the configuration of your server. Clear the Run the SharePoint Products and Technologies Configuration Wizard now check box.

SharePoint 2016 Installation Completed

7- Click Close to finish Setup.

8- Restart the Server

9- DO NOT RUN THE PRODUCTS CONFIGURATION WIZARD

Before you start, verify that you are logged on and running as the SharePoint Admin account.

Important: The initial server that you run the wizard on to create a new farm will be the default server name to access the SharePoint Central Administration site. For example, if the initial server is SPProd01, then Central Admin will be http://SPProd01:8181.

For latest SharePoint 2016 Feature Pack installation check SharePoint Server 2016 Feature Pack Installation

Check SharePoint Product configuration wizard detail in SharePoint 2016: Products Configuration Wizard.

SharePoint Performance Issue- Set Memory Limits on SQL Server

By default, SQL Server is set to use max 2TB of RAM. You might not be having 2TB RAM in your environment, you might have 8GB, 16GB or more depending on your farm and SharePoint installation. Here is a formula to determine memory size for all instances of SQL Server.

SQL Max Memory= TotalPhysicalMemory – (NumberOfSQLThreads * ThreadStackSize) – (1GB * CEILING(NumberOfCores/4))

NumberOfSQLThreads = 256 + (NumberOfProcessors*- 4) * 8 (* If NumberOfProcessors > 4, else 0)

ThreadStackSize = 2MB on x64 or 4 MB on 64-bit (IA64)

We recommend to set Maximum Server Memory calculated as Available RAM – 2GB (for OS). This may be increased as needed up to 2TB.

This is one of the know issue that SharePoint server getting slow with time due to SQL Server which is taking most of the RAM on the system, so it’s important to define the memory limit to SQL Server instead of using the default limit.

To set memory limits in SQL Server

1 – Open SQL Server management studio.

2 – Right click on server and select properties from context menu.

SQL Server 2016 - Properties

3- Select Memory in left navigation of Server Properties to bring up Server memory options. Maximum memory show in diagram below is just for illustration purpose.

SQL Server 2016 - Memory