Come along with me on a small adventure into the world of free SharePoint. Yes, free! SharePoint Foundation 2013 is technically free (well, included in your existing Windows licenses) and can do a whole lot for you without needing to spend significant amounts of money on Server editions. I am going to walk through a mini-series around SharePoint Foundation: installing (this post), what features it contains (and does not), how it can fulfill some use cases and finally a wrap up discussing if Foundation is a viable solution for companies both large and small.
Downloading SharePoint Foundation
Finding SharePoint Foundation was not as easy as one would expect. Going to www.sharepoint.com, and clicking Try or Buy didn’t render a link. I clicked Try Now under SharePoint Server 2013. Then off to the right under Related Downloads is a link for SharePoint Foundation 2013. Wait, that doesn’t have SP1 which is required for Windows Server 2012 (but SP1 has been retracted, hasn’t it?), so I searched some more and found it. Lucky for you, you can download it from: http://www.microsoft.com/en-us/download/details.aspx?id=42039. If you’re running Windows Server 2008, you can download it without SP1: http://www.microsoft.com/en-us/download/details.aspx?id=35488. Looks like Microsoft doesn’t necessarily want to show off this free version is readily available.
Requirements for Foundation are similar to the Server versions. Check out the hardware and software requirements here.
I am installing it in VMWare, with 8GB RAM and 2 cores. It’ll be slow but that’s okay for now. I already have Windows 2012 R2 Standard installed, and I have SQL Server 2012 Standard with SP1 installed on another VM. SQL has been configured with a named instance SPF2013A for this specific instance of SharePoint.
I need SQL too?
SharePoint runs on Microsoft SQL, period. Sorry, you can’t run on MySql or any other variation out there. If you don’t have access to SQL server, you can either install SharePoint in a single server instance which includes SQL for you, or better yet, download and install SQL Express (free). Note there are limitations, but if you’re doing a quick POC or trying out SharePoint, SQL Express will probably be fine. I recommend installing SQL separately as it’ll allow you to expand on your new SharePoint farm in the future. Even if you don’t have plans to expand this farm, install SQL separately, as your production farm will be using this model. I do not cover installing SQL, as there are many flavors and options.
SharePoint utilizes Active Directory for permissions and such, starting at installation. You cannot install it on a server without AD. You shouldn’t install it on a server that is the AD domain server, though it will probably work, it’s not supported by Microsoft.
Create the following AD accounts for your SharePoint install. You can go crazy and use a service account for every service in SharePoint, allowing for an incredible amount of security separation (and maintenance) but being realistic, I prefer to use the following. Each account has to be a domain account, not a domain admin, just a domain user.
- Farm admin account, i.e. spfarm.
- This account will be the installation account, and SharePoint will setup the permissions for the rest of the accounts.
- Needs local administrative rights to your SharePoint server, excluding SQL.
- Account must be setup with dbcreator and securityadmin roles in SQL.
- Application service account, i.e. appsvc. This account will be used to run your service applications in SharePoint.
- Web service account, i.e. websvc. This account will be used to run your web sites services and application pools.
Prior to installing SharePoint on your server, you’ll need to setup your server to handle a web site. Add the Application Server and Web Server (IIS) roles. Also include Application Server Role Services Web Server (IIS) Support.
Check your SQL Server’s properties, specifically the Max Degree of Parallelism of a value of 1. Check out http://www.sharepointpitstop.com/2013/04/max-degree-of-parallelism-error.html for more details, I ran into this issue myself ;).
Installing SharePoint Foundation
Now that you’ve found and downloaded SharePoint Foundation, got SQL setup, let’s install SharePoint! First, log in with your spfarm account, and then run the install file you downloaded, and you’ll get the lovely blue splash screen.
Click Install software prerequisites, under the Install section. This installs all the stuff SharePoint needs to run.
Just accept defaults and walk through this wizard. This wizard will probably require your server to restart. It may need to reboot a couple of times depending on how many updates it has to do.
Log back in and rerun the installer. Back at the blue screen, press Install SharePoint Foundation. Most of the installation will be pretty basic: accept the terms, press continue. For Server Type, select Complete and press Install Now.
When done, you can go ahead and press Close.
So far so good? The SharePoint bits, the binaries and files, are installed! Now onto the fun part and configuring SharePoint!
The SharePoint Products Configuration Wizard will appear next. Click Next then Yes to the warning. On the next page, select Create a new server farm.
On the next screen, enter your details for the SQL server, and use your spfarm account for its credentials. I have the \SPF2013A because I installed SQL with another instance, you can probably leave yours as the server name.
Specify a passphrase. Important! This passphrase will be needed if you want to add another server to your farm in the future. Keep it safe!
On the next screen, you can leave it as default, or specify a port number. If you decide to specify your own port, do not specify any of the standard web ports like 80, 443, 8080, etc. This should be a unique port number as central administration is the core of SharePoint, all configuration, permissions and such occurs here.
Click Next a couple more times and the configuration will run. It may take a while depending on hardware and what not. Let it run. It will error if there’s a problem, otherwise, no news is good news.
Success! Click Finish and Central Administration will open.
After a successful installation, Central Administration should open. If for some reason it doesn’t, you can open it from the Programs menu.
When Central Administration opens first, it’ll ask if you want to help make SharePoint better. Do as you wish, it’s your conscience.
So you have an option to here to use a wizard to configure SharePoint.
I prefer not to use the wizard, I’m a hands on kind of guy. The wizard is ok, and if you’re going to do a quick and dirty proof of concept, I guess you could do that. I will, however, carry us through the entire process, I’m going to press Cancel. That will bring us out to Central Administration:
Before we make any new sites, we have to continue to configuring SharePoint to get ready. Click Security in the left quick launch, and then click Configure managed accounts.
Add your service accounts. In my case, I added the 2. What’s nice is if you fat finger the password, it will prompt you. This is nice since that will not cause issues down the road.
Once added, click Application Management, then click Manage Service Applications.
If you click new in the top ribbon, you’ll see a few options. We’re going to add each of these. Start with the App Management Service. Fill out the following in the dialog:
- Name. I go with something clear, like “App Management Service”
- Database. This should default to your SQL server, and you can leave it as is.
- Failover Server. If you have one, you can specify it, otherwise continue on.
- Application Pool. We do want to create a new application pool.
- Application pool name, specific Application Services.
- For the security account, select Configurable and select the appsvc account from the picker.
- Create App Management Service Proxy. Keep the Create option checked.
- Click OK.
Next up, create a new Secure Store Service.Why did I skip the Business Data Connectivity Service? Because we don’t need it. This service allows SharePoint to connect to external data systems, like another SQL database. If you want to use it, go for it, but for most POCs, we don’t need it.
Ok, back to the Secure Store Service.
- Name: Secure Store Service.
- Database. Again, this should default, let’s move along.
- Failover Server. Ya, again, move along.
- Application Pool. This time, let’s select an existing application pool, specifically the one we made before, Application Services.
- Enable Audit. Keep that checked.
- Click OK.
Couple more small things. Click on System Settings, then Configure outgoing e-mail settings. Specify your outgoing email server. You can simply put your Exchange server here. You’ll have to allow relaying from the SharePoint server IP address. SharePoint does not authenticate with the outgoing email server.
If you want, you can validate the outgoing email by setting up a relay on the SharePoint server. This works well with Exchange or any cloud based email service. Check out my other post on Sending SharePoint emails through the cloud.
Click System Settings then Manage Services on Server.
Now we have to turn a bunch of stuff on. Turn on the following:
- App Management Service.
- Microsoft SharePoint Foundation Subscription Settings Service.
- Secure Store Service.
Create your first site
Now that SharePoint is configured and ready to go, let’s create a site. The site itself will be what your users access. Click Application Management then Manage web applications.
Brief overview of SharePoint’s architecture
The SharePoint farm is what we have now. It’s SharePoint, installed and configured. It can be installed across multiple servers. Note we didn’t have to install SharePoint on SQL. SQL simply stores the databases, however SQL is still considered part of the farm.
Web applications are the top level of data collections. As you’ll see, Central Administration has a web app. A web app is a collection of Site Collections.
Site collections are a collection of sites, and can contain one to many sites.
Sites are the interfaces your users go to to access SharePoint. Sites contain lists, libraries and all the user data.
Create your web application
Click New in the ribbon. Fill out the page as follows:
- IIS Web Site. SharePoint will create the following IIS web site on your farm. Keep port 80, specify a host header. For quick and dirty, you can specify your server’s name, in my case spf2013a. If you want something more meaningful, specify a valid name which has been setup in your DNS.
- Security Configuration. You can leave this as is.
- Claims Authentication Types. Leave it.
- Sign In Page URL. Move on.
- Public URL. Ditto.
- Application Pool. We’re going to create a new one, keeping the default name is fine. Under the security account, select your websvc.
- Database Name and Authentication. You can leave the database name as is, however I generally append the site name to the database name so I know what database goes to which site.
- Failover Server. Ya, you know.
- Service Application Connections. Move along.
- Customer Experience Improvement Program. Again, up to you.
- Click OK.
Create your site collection
When the web application finishes, the confirmation window will have a link to create a site collection, click that.
If you were so excited to have setup your web app that you closed that confirmation window. Click Application Management, then Create site collections.
In the Create Site Collection dialog, specify the following:
- Title and Description. The title is the name of the site, what your users will see. This can be changed at any point later. Not as stressful as naming your kid, but close. You can leave description blank.
- Web Site Address. Keep the / selection.
- Template Selection. Select a Team Site. This is a basic site, a great starting point.
- Primary Site Collection Administrator. Select the smartest person you know, yourself! Specify your user name in here so you can easily get into the new site.
- Secondary Site Collection Administration. Select the other administrator of the site. You can specify more later on.
- Quota Template. Leave with No Quota.
- Click OK.
Tech Tip: Now access all your business applications at a ease of a single click on your preferred device(PC/android/iOS) with hosted virtual desktop from CloudDesktopOnline.com with Add-ons like SharePoint and Exchange. If you prefer a server, Rent a server with 24*7 dedicated migration and tech-support from www.Apps4Rent.com.
You’re ready to go!
That’s it! You should be all set to go! We didn’t have to create a site, as a site collection always has a default root site within it.
If you try to hit the site from the server console, you may have an issue, check out this post for an easy fix.
- Click the cog, or the gear, or the little circle looking thing in the top right, then go to Site Settings. This is all the behind the scenese including permissions, Look and Feel, search settings and a whole lot more. Familiarize yourself with what’s here.
- Click the cog, then Add an app. This is how you add new lists and libraries.
- Click the cog, then Site Contents. This shows all content on the current site. This is also where you can create new sub sites, scroll down and you’ll see a link for new subsite.
Til next time, Happy SharePointing!
Looking for the next part? Sorry I’m a slacker! Leave comments below and I’ll finish it off.
Great how to. One more thing that I had problems with and took a while to figure out. As we all know Group Policy can be a pain.
Make sure that the users are in the following Local Group Policies
User Rights Management – “Log on as batch”, and “Log on as service”.
I am still wondering if the farm account needs to be a local admin? I get the warning message in Central Administration about it.
Works like a champ except there is no Search Application, Any chance for a little guidance
Yea, that’s where I stopped. The next step is to grab search express I believe it’s called and install, but haven’t done it yet. With O365 and Sp2016, I haven’t had time to go back. If you realllllly want it I could get it done for ya ;)
I followed along quite easily, works great except 1 thing, There is no search application installed/configured. I’ve found other articles how to add but am confused about which domain/accts to use appsvc or websvc etc. Kind of a big miss there
There may of the things that people find
I cant get by “Specify Confi… Database Settings” Im unclear what to put, or how to find what to put, in “Database Server”. SQL is running but Im not sure that its setup for what I want it to do. Remote assistance via TeamViewer would be greatly appreciated and PAID FOR!!!
Hi Joey, do you still need assistance? Email me at david.lozzi at slalom.com.
This got me through all of the errors I was getting during install and config. Thanks!!!
I will try it on a standalone server installation in the near future. I did get it to eventually work when I removed from the DC with AD.
could not get the sql 2014 express to install correctly. it would never start. Followed your instructions. This , luckely, is on a test vm.
Any errors or logs sharing any helpful information?
Hi – just a quick question.
on the screenshot of your central Admin – you have the “” in the Navigation. Any idea what causes this?
On several of the machines I have configured this is also the case, and I haven’t found a solution yet.
Hi, thanks for the great guide!
One question though: should “spfarm” remain in “local administators” on my SP server? I get a warning in Central Administration about Service accounts having local admin rights and I read on several other sites that the farm account does not need to be in “local administators” (e.g. http://sharepoint.stackexchange.com/questions/22075/should-my-farm-account-be-in-the-local-admins-group).
What Db’s are created when you first install the SharePoint server 2013 in backend DB
I would like to install in Windows 7?
with SharePoint 2010 it was possible to install in Vista…
Sadly you can only install on server operating systems, yeah, this is new with 2013, and a shame. ;)
of course i will
Can i use sql web edition to
To…. suspense is killing me :-p
I assume you want to know if the web edition will work with Foundation. I believe yes, though I haven’t tried. The documentation is clear enough to say SharePoint requires SQL, but doesn’t appear to care about what version. I briefly reviewed the Web Edition and it appears to offer more than the Express, so I’d guess Web will work. If you try it out, let me know how it goes!
Very good. Many thanks. How do I choose a custom port number to install SharePoint Foundation, for example 8080? I have followed your instructions but do not find an option to choose a port number for SharePoint itself. Must it always be installed on the default port?
Port for what part of SharePoint? Do you mean the team site your users gain access to?