Difference between SharePoint Farm & Standalone Installation

Hi friends, this article is about SharePoint installation. Different types of SharePoint installation and difference between them. we will also see limitations of each installation type. The main objective behind this article is to become familiar with difference between SharePoint Farm and Standalone installation.

Types of SharePoint Installation

There are two types of SharePoint installation as ‘Standalone’ and ‘Farm’ installation. Standalone installation will install SQL Express on your machine and use it to provide SharePoint services. Farm will install SharePoint on network or on existing SQL server.

Difference between Farm & Standalone Installation

Farm Installation

Standalone Installation

1)      It allows you add servers so as to keep from running out of resources.


1)      No additional servers can be added and hence it has limitation of database.


2)      Offer greater scalability and performance. Multiple servers like 2008 R2 Express having 10GB of database can be added.


2)      Less scalability and performance as compare to Farm installation because only one SQL Server having limit of 4GB of database can be installed.


3)      You can join other machines to this installation.


3)      No other SP machine can join this installation.


4)      You have more control over server configuration.


4)       All server configuration will be done automatically using standard settings and local service accounts.


Limitations of Standalone Installation:

  1. Standalone installation has SQL database limit of 4GB.
  2. As standalone is configured in one server only so no Domain accounts can be used. It runs under local accounts like Network Service account therefore we can not create user profile services.
  3. We can not backup the data and restore it from standalone installation to multiple servers farm and vice and versa.

If you like this article, please share it with your friends and like or facebook page for future updates. Subscribe to our newsletter to get notifications about our updates via email. If you have any queries, feel free to ask in the comments section below. Have a nice day!

Leave a Reply