Sharepoint 2013 foundation: installation and configuration

Windows Server 2019

Introduction

In this tutorial, we will see how to set up Sharepoint 2013 foundation on Windows 2012R2.

Although this version at the time of writing this article is more than 5 years old, it allows to discover Sharepoint before making its acquisition.

SharePoint is a web portal that allows to set up within a structure a collaborative platform that allows:

  • Electronic Document Management (EDM)
  • Task Management
  • Documentation Center (FAQs, articles …)

In this tutorial, I dedicated a server to Sharepoint with the databases.

Prerequisites

In order to set up Sharepoint you need:

  • An Active Directory environment
  • A Windows 2012R2 server with two partitions, one of which is dedicated to the SQL Server (Express) instance.

Before you start preparing the server for the Sharepoint installation download the following items to the Sharepoint server in a source folder:

  • Sharepoint 2013 SP1 Foundation on the site of Microsoft.
  • WCF Data Services 5.6, once the downloaded file rename it in: WcfDataServices56.exe
  • Retrieve scripts PowerShell for the installation of the prerequisites.

Where you downloaded the scripts create a sp-prereq folder. The Sources folder should look like the catch below:

Sharepoint prepare install

Installing the prerequisites for Sharepoint 2013

Installing Windows Server Roles

Start a PowerShell command prompt in Administrator and run the Install-SP2013RolesFeatures.ps1 script to install the necessary roles for Sharepoint, confirm the installation with the default choice.

Install Roles

Wait during the installation …

Wait during install

The installation completed, confirm the restart of the server.

Install completed

Downloading prerequisites

Start a PowerShell command prompt in Administrator and run the Download-SP2013PreReqFiles.ps1 script to download the necessary files.

Script download files

Indicate the location where the files will be saved.

Folder save files

Wait while downloading the prerequisites …

Downloading files

The download of the files is finished.

Download completed

Preparing to install the prerequisites

In the folder where the files are stored, create a PrerequisiteInstallerFiles folder and then move the downloaded files in by also putting the WcfDataServices56.exe file.

Open the Sharepoint 2013 installation archive with 7zip and extract the prerequisiteinstaller.exe and msvcr100.dll files to the parent folder of PrerequisiteInstallerFiles.

Folder prerequisite

Installation of the prerequisites

During the installation of prerequisites, several reboots are needed

From a PowerShell command prompt to an administrator, run the Install-SP2013PreReqFiles.ps1 file and specify the folder where the prerequisiteinstaller.exe file is located.

Start script

The installation wizard starts, click Next 1 .

SharePoint 2013 prerequisite installation wizard

Check the box to accept the 1 license agreements then click Next 2 .

Accept license

Wait during the installation …

Wait during install

Restart the server by clicking Finish 1 .

Reboot server

When the installation is complete, close the wizard by clicking Finish 1 .

Install completed

Sharepoint 2013 installation


Run the Sharepoint 2013 installation file 1 .

Launch executatable Sharepoint 2013

Waiting for the extraction of the files …

Extracting files for install Sharepoint 2013

Click Install SharePoint Foundation 1 .

Start install Sharepoint 2013

Check the box 1 to accept the license agreement and click Continue 2 .

Accept license Sharepoint 2013

Choose the option Complete installation 1 and click on the tab Data location 2 .

Type of installation for Sharepoint 2013 server

Indicate the location of the data 1 and click on Install now 2 .

Sharepoint 2013 folder data

Wait during the installation …

wait during install sharepoint 2013

The installation is complete, check box 1 Run the SharePoint Products Configuration Wizard and click Close 2 .

SharePoint 2013 installed

Post-installation configuration of SharePoint 2013

In this part, we will configure the server farm as well as the SQL Server instance for SharePoint.

When launching the wizard, click Next 1 .

Wizard config SharePoint

Click Yes 1 to confirm the (re) start of the services needed for Sharepoint 2013.

Start services

Since this is the first server, select the option Create Server Farm 1 and click Next 2 .

Create farm

Indicate the 1 SQL server and the identifiers to connect 2 then click Next 3 .

Config SQL Server

In a production environment, it is recommended to use an account dedicated to SharePoint.

Enter a secret phase 1 then click Next 2 . This sentence will be requested when adding a new server to the farm.

Secret password for farm

Configure access to the administration interface, if necessary change the proposed port number and the authentication method and click Next 1 .

Admin center

A summary of the configuration is displayed, click Next 1 .

Resume config

Wait while configuring the SharePoint 2013 server farm …

wait

Once the configuration is complete, close the wizard by clicking the Finish 1 button.

completed sharepoint 2013 configuration

In the DATA folder of SQL Server, we can see that several databases have been created.

SharePoint 2013 - Databases

SharePoint configuration

Now that the SharePoint 2013 services are installed and configured, you must configure SharePoint itself.

Start an Internet browser and enter the address of the Administration Center, if they are asked to enter identifiers.

Login

Choose an option for improvement program 1 and click OK 2 .

Click the Start Wizard 1 button to configure the server farm and create the first site.

Start Wizard

Set up a 1 service account, choose 2 farm services, and click Next 3 .

Select services

In production, it is advisable to dedicate an account for SharePoint services.

Wait during configuration …

wait

Set the root site 1 and click OK 2 .

First site

Wait while creating the site …

Configure first site - wait ...

The configuration is complete, click Finish 1 to return to Central Administration.

Configuration completed

From Central Administration, it is possible to configure all SharePoint 2013 services, create new sites, manage databases …

Sharepoint 2013 - Admin Center

To access the site just created, go to the root address of the Sharepoint server.

Sharepoint Home

As administrator of the site, it is possible to customize from the different pages that compose it.

The rest of the tutorial will explain:

  • how to configure access rights to the site
  • add and use a document management.

Setting permissions


Now that we have a SharePoint site, we need to configure permissions, so people can access the site.

From the homepage of the site, click on the settings icon 1 then on Shared with 2 .

Share site

Click on Advanced 1 .

Add right

By default 3 groups are predefined. We will add the right of collaboration to Everyone, if we put this group with the permission of Modification (SharePoint – Members), they will be able to modify the pages. Click on Grant permissions 1 .

Grant permissions

Enter the name of the group 1 and click on Show options 2 .

Configure permissions

Choose Collaboration 1 and click on Share 2 .

Select permissions

Permissions have been added.

Permissions added

The document library

The document library is SharePoint component, which allows you to create a page on a site similar to a shared folder on a file server. It allows you to group files in a common space, it is also possible to create folders to improve the classification. This component is very popular because the files deposited in it are indexed, which makes it possible to carry out research as well on the name of the file as on its contents. The component also supports the versioning which allows to return to an earlier version of the file.

The other advantage is that you can map computers to the library as a network drive, which makes it possible to centralize documents on SharePoint.

All files stored in the library are stored in the database, if you use a SQL EXPRESS server, the size per base is limited to 10GB. It is possible in SharePoint to create multiple content databases and assign them to different sites.

Add a document library

From the home page, click Add Lists, Libraries and 1 .

Add composant

Click on 1 Document Library.

Add composant

Enter the name 1 of the library then click on Create 2 .

Library name

The library is added 1 , click on its name 2 in the navigation menu on the left to open it.

Library added

Add a document

To add a document, you can either drag it into the database by drag and drop or click on New Document 1 .

New file

Select file 1 and click OK 2 .

Select file

Wait while sending …

Upload file in SharePoint 2013

The file is added to the library.

File added

Access the library by the explorer

From the page of this one, in the banner click on Library 1 and click on the corresponding icon 2 .

Sharepoint 2013 - library

The library is available from the explorer, note the path of it 1 . It is in the form http: // server / sites / library.

Sharepoint 2013 - Library in explorer

To connect to a network drive, enter the URL 1 in the Folder field.

Libray in explorer

The network drive is mapped to the SharePoint 2013 1 library. It should be possible to map the drive by GPO.

Library SharePoint 2013 as a network drive

Enable version control

Access the 1 settings of the library.

Param library - sharepoint 2013

Click Version Control Settings 1 .

SharePoint 2013 - Parameters Library

Activate the versions by selecting one of the two options 1 , indicate the number of versions to keep 2 and click on OK 3 .

Configure versions

Version control is now enabled.

Sites in SharePoint

SharePoint makes it possible to create several sites, which makes it possible to cut the collaborative space into service for example. In this part, we will create a site dedicated to the IT department.

Add a site

On Central Administration, click Create Site Collections 1 .

Sharepoint 2013 add site

Give a 1 name and description to 2 . Configure the url of the site 3 then click on OK 4 .

Configure site

Wait while creating …

Wait

The new site is created, click on the link 1 to open it.

Site created

All that remains is to add components to the sites and configure the permissions.

Add a content database

It is possible to configure multiple content databases in SharePoint and assign a site to it. In terms of now and in case of restoring SharePoint this facilitates operations.

A devious advantage for users of SQL Express is to have multiple sites that do not share the same database and therefore have 10GB of space per site.

In Central Administration, click on Application Management 1 and then on Manage Content Databases 2 .

Application management

Click Add Content Database 1 .

Add database - Sharepoint 2013

The parameters are normally filled in, change the database name 1 and click OK 2 .

Param database

Wait while creating …

wait

The database is created.

Database created

You can also check the files in the DATA directory of the SQL SERVER instance.

Databases files

Change the content database of a site

Open Sharepoint 2013 Management Shell as Administrator and enter the following command to change the database database:

Move-SPSite  -DestinationDatabase 

To move the IT site on the basis of WSS_Content_2:

Move-SPSite http://lab-sp/sites/it -DestinationDatabase WSS_Content_2

Confirm the move and once it is finished restart IIS.

It is possible to check the database in Central Administration, by going to Manage Applications / View All Site Collections. Select the site by clicking 1 and check the database 2 in the information.

Site informations

Conclusion

This tutorial on SharePoint 2013 stops here and I hope it will help you set it up. Other tutorials on SharePoint will follow, because it would be reductive to limit it to document management.

It is a powerful collaborative tool that can help services become more efficient by sharing information and working together.

Romain Drouche
System Architect | MCSE: Core Infrastructure
IT infrastructure expert with over 15 years of field experience. Currently a Systems and Networks Project Manager and Information Systems Security (ISS) expert, I use my expertise to ensure the reliability and security of technological environments.

Leave a Comment