{"id":1442,"date":"2014-07-28T05:03:27","date_gmt":"2014-07-28T12:03:27","guid":{"rendered":"https:\/\/www.netometer.com\/blog\/?p=1442"},"modified":"2025-10-21T17:46:03","modified_gmt":"2025-10-22T00:46:03","slug":"how-to-install-sharepoint-foundation-2013-with-sql-server-2014-express","status":"publish","type":"post","link":"https:\/\/www.netometer.com\/blog\/?p=1442","title":{"rendered":"How to Install SharePoint Foundation 2013 with SQL Server 2014 Express"},"content":{"rendered":"<p>&nbsp;<\/p>\n<div class=\"gk-legend\" data-style=\"style3\"><strong>Screencast :<\/strong><strong>SharePoint 2013 Installation on Server 2012 R2<\/strong><\/p>\n<ul data-style=\"style6\">\n<li><span style=\"color: #4494dd;\"><strong>Create and configure the required domain accounts<\/strong><\/span><\/li>\n<li><span style=\"color: #4494dd;\"><strong>Slipstream the latest SQL Server 2014 CU into the installation files<\/strong><\/span><\/li>\n<li><span style=\"color: #4494dd;\"><strong>Optimize SQL Server 2014 for SharePoint 2013<\/strong><\/span><\/li>\n<li><span style=\"color: #4494dd;\"><strong>Install SharePoint 2013 and perform the initial Farm configuration<\/strong><\/span><\/li>\n<\/ul>\n<\/div>\n<p>In this step-by-step <strong><a title=\"How to Install SharePoint 2013 with SQL Server 2014\" href=\"https:\/\/www.netometer.com\/video\/tutorials\/How-to-Install-SharePoint-2013-Foundation\" target=\"_blank\" rel=\"noopener\">Screencast <\/a><a title=\"How to Install SharePoint 2013 with SQL Server 2014\" href=\"https:\/\/www.netometer.com\/video\/tutorials\/How-to-Install-SharePoint-2013-Foundation\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.netometer.com\/blog\/wp-content\/uploads\/video-icon.png\" alt=\"How to Install SharePoint 2013 with SQL Server 2014\" width=\"25\" height=\"21\" \/><\/a><\/strong>, we demonstrate how to install SharePoint 2013 Foundation on Server 2012 R2. In addition, we demonstrate in details the installation, configuration, and optimization of SQL Server 2014 Express for SharePoint 2013 on a separate Windows 2012 R2 member server, which is the so called two-tier deployment.<\/p>\n<p>SharePoint 2013 Foundation and SQL Server 2104 Express are both free editions and come with certain limitations. As you will see in our demo, the SQL Server 2014 Express memory limits are actually higher than the official 1GB buffer cache per instance. In addition, implementing Remote Blob Storage (using the FileStream provider) allows documents and files to be stored on the file system instead of inside the database itself. As a result, you get improved performance, and you get past the 10GB per database SQL express limit for your content databases. To keep things simple, we will demonstrate configuring Remote Blob Storage with SharePoint 2013 using SQL Server 2014 Express in a separate Screencast. <\/p>\n<div id=\"kgvid_kgvid_0_wrapper\" class=\"kgvid_wrapper\">\n\t\t\t<div id=\"video_kgvid_0_div\" class=\"fitvidsignore kgvid_videodiv\" data-id=\"kgvid_0\" data-kgvid_video_vars=\"{&quot;id&quot;:&quot;kgvid_0&quot;,&quot;attachment_id&quot;:1443,&quot;player_type&quot;:&quot;Video.js v8&quot;,&quot;width&quot;:&quot;800&quot;,&quot;height&quot;:&quot;600&quot;,&quot;fullwidth&quot;:&quot;false&quot;,&quot;fixed_aspect&quot;:&quot;false&quot;,&quot;countable&quot;:true,&quot;count_views&quot;:&quot;quarters&quot;,&quot;start&quot;:&quot;&quot;,&quot;autoplay&quot;:&quot;false&quot;,&quot;pauseothervideos&quot;:&quot;false&quot;,&quot;set_volume&quot;:&quot;1&quot;,&quot;muted&quot;:&quot;false&quot;,&quot;meta&quot;:true,&quot;endofvideooverlay&quot;:&quot;&quot;,&quot;resize&quot;:&quot;true&quot;,&quot;auto_res&quot;:&quot;automatic&quot;,&quot;pixel_ratio&quot;:&quot;true&quot;,&quot;right_click&quot;:&quot;on&quot;,&quot;playback_rate&quot;:&quot;false&quot;,&quot;title&quot;:&quot;How-to-Install-SharePoint-2013-Foundation&quot;,&quot;skip_buttons&quot;:[],&quot;nativecontrolsfortouch&quot;:&quot;true&quot;,&quot;locale&quot;:&quot;en&quot;,&quot;enable_resolutions_plugin&quot;:false}\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.netometer.com\/blog\/wp-content\/uploads\/How-to-Install-SharePoint-2013-Foundation_thumb120.jpg\"><meta itemprop=\"embedUrl\" content=\"https:\/\/www.netometer.com\/blog\/wp-content\/uploads\/How-to-Install-SharePoint-2013-Foundation.mp4\"><meta itemprop=\"contentUrl\" content=\"https:\/\/www.netometer.com\/blog\/wp-content\/uploads\/How-to-Install-SharePoint-2013-Foundation.mp4\"><meta itemprop=\"name\" content=\"How-to-Install-SharePoint-2013-Foundation\"><meta itemprop=\"description\" content=\"How to Install SharePoint Foundation 2013 with SQL Server 2014 Express\"><meta itemprop=\"uploadDate\" content=\"2014-07-28T04:53:49-07:00\">\n\t\t\t\t<video id=\"video_kgvid_0\" playsinline controls preload=\"metadata\" poster=\"https:\/\/www.netometer.com\/blog\/wp-content\/uploads\/How-to-Install-SharePoint-2013-Foundation_thumb120.jpg\" width=\"800\" height=\"600\" class=\"fitvidsignore video-js kg-video-js-skin\">\n\t\t\t\t\t<source src=\"https:\/\/www.netometer.com\/blog\/wp-content\/uploads\/How-to-Install-SharePoint-2013-Foundation.mp4?id=0\" type=\"video\/mp4\" data-res=\"600p\">\n\t\t\t\t<\/video>\n\t\t\t<\/div>\n\t\t\t<div style=\"display:none\" id=\"video_kgvid_0_meta\" class=\"kgvid_video_meta kgvid_video_meta_hover \">\n\t\t\t\t<span class='kgvid_meta_icons'><\/span>\n\t\t\t\t<span id='video_kgvid_0_title' class='kgvid_title'>How-to-Install-SharePoint-2013-Foundation<\/span>\n<\/div>\n\t\t<\/div>\n<ul data-style=\"style5\">\n<li><a title=\"How to Install and Configure Remote Blob Storage in SharePoint 2013 and SQL Server 2014.\" href=\"https:\/\/www.netometer.com\/video\/tutorials\/SharePoint-2013-SQL-2014-Remote-Blob-Storage\" target=\"_blank\" rel=\"noopener\">How to Install and Configure Remote Blob Storage in SharePoint 2013 and SQL Server 2014.<\/a><\/li>\n<li><a title=\"SQL Server 2014 Express Actual Memory Limit.\" href=\"https:\/\/www.netometer.com\/blog\/?p=1451\" target=\"_blank\" rel=\"noopener\">SQL Server 2014 Express Actual Memory Limit.<\/a><\/li>\n<li><a title=\"How to Start and Configure SharePoint Foundation 2010 Search\" href=\"https:\/\/www.netometer.com\/video\/tutorials\/Configure-Start-SharePoint-Foundation-Search\" target=\"_blank\" rel=\"noopener\">How to Start and Configure SharePoint Foundation 2010 Search<\/a><\/li>\n<li><a title=\"How to Install and Configure Search Server 2010 Express\" href=\"https:\/\/www.netometer.com\/video\/tutorials\/How-to-Install-and-Configure-Search-Server-Express\" target=\"_blank\" rel=\"noopener\">How to Install and Configure Search Server 2010 Express<\/a><\/li>\n<\/ul>\n<p><a class=\"twitter-hashtag-button\" title=\"SharePoint 2013\" href=\"https:\/\/twitter.com\/intent\/tweet?button_hashtag=SharePoint2013\">Tweet #SharePoint 2013<\/a> <a class=\"twitter-follow-button\" href=\"https:\/\/twitter.com\/netometer\" data-show-count=\"false\">Follow @netometer<\/a><\/p>\n<p>Stay tuned on <strong><a title=\"NetoMeter - Screencasts and Step-by-Step Video Tutorials\" href=\"..\/..\/blog\/?feed=rss2\" target=\"_blank\" rel=\"noopener\">NetoMeter<\/a><\/strong> &#8211; subscribe to<a title=\"NetoMeter - Screencasts and Step-by-Step Video Tutorials\" href=\"..\/..\/blog\/?feed=rss2\" target=\"_blank\" rel=\"noopener\"> <strong>NetoMeter RSS<\/strong><\/a>.<\/p>\n<p>Dean<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SharePoint 2013 Foundation and SQL Server 2104 Express are both free editions and come with certain limitations. As you will see in our demo, the SQL Server 2014 Express memory limits are actually higher than the official 1GB buffer cache per instance. In addition, implementing Remote Blob Storage (using the FileStream provider) allows documents and files to be stored on the file system instead of inside the database itself. As a result, you get improved performance, and you get past the 10GB per database SQL express limit for your content databases.<\/p>\n","protected":false},"author":1,"featured_media":1444,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","footnotes":""},"categories":[361,325],"tags":[431,429,432,428,430],"_links":{"self":[{"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1442"}],"collection":[{"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1442"}],"version-history":[{"count":0,"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1442\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/1444"}],"wp:attachment":[{"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.netometer.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}