Installing Share. Point 2. 01. 3 Preview on Windows 2. Server with SQL 2. Welcome back to part 2 on installing Share. Point 2. 01. 3 Preview on Windows 2. In part 1 we focused on installing SQL 2. Windows 2. 01. 2 server and in todays post we focus our efforts on getting Share. Point 2. 01. 3 and its prerequisites installed and configured on a second dedicated Windows 2. Applications and Web Front End server. As previously stated, for development and testing purposes, you can install Share. Point 2. 01. 3, Active Directory and SQL on the same box. Articles in this series Installing Share. Point 2. 01. 3The Preparation Installing Share. Point 2. 01. 3Before we delve into the actual installation, lets begin to talk about what service accounts are required for the new Share. Point 2. 01. 3 Farm setup. There isnt much documentation apart from the Share. Point 2. 01. 3 deployment guide or best practices noted yet for service accounts in Share. Point 2. 01. 3, but we will adopt what we have learnt and accustomed to in Share. Point 2. 01. 0.  Even though you can use one account for all, Microsoft will always recommend that you install Share. Point 2. 01. 3 by using least privilege administration. The below describes the accounts that will be used to install and configure Share. Point 2. 01. 3. SQL Server Service Account. This should be a standard domain user account which will be used to run the MSSQLSERVER and SQLSERVERAGENT services on your SQL server. DOMAINspsql. Share. Point SetupInstall User Account. This should be a standard domain user account that will be used as the logged in user when installing Share. Point 2. 01. 3 and for when running the Share. Point Products Configuration Wizard. This account must be a member of the Local Administrators group for each server where Share. Point 2. 01. 3 will be installed. You will also need to create a SQL server login with the following SQL server security roles securityadmin and dbcreator. I have posted instructions below. Please note that if you run Windows Power. All Posts in this Blog Certification Study Guides. Core Solutions of Microsoft SharePoint Server 2013 Study Guide 70332 Study Guide Advanced Solutions. Z_T84uQ/UCPMMRhJP4I/AAAAAAAAAJ8/xTFHHGY93_I/s1600/CentralAdd.png' alt='Microsoft Sharepoint Products Preparation Tool 2013' title='Microsoft Sharepoint Products Preparation Tool 2013' />Shell cmdlets that affect a database, this account must also be a member of the dbowner fixed database role for the databasee. DOMAINspinstall. Server FarmDatabase Access Account. This account is also a standard domain user account, however we do not need to grant any necessary permissions to this account as this is handled by the Share. Point Setup User Account during the Share. Point Products Configuration Wizard. This is the account that we nominate as the Database Access account during the Share. Welcome back to part 2 on installing SharePoint 2013 Preview on Windows 2012 In part 1 we focused on installing SQL 2012 on a Windows 2012 server and in todays. There are a tremendous amount of Microsoft products that are cloudbased for building big data solutions. Its great that there are so many products to choose from. Summary Lists the minimum hardware and software requirements to install and run SharePoint 2013. SharePoint Server 2013 includes a wide variety of improvements and new features. Discover how SharePoint Server gives you new ways to share your work, work with. OI8UFxs/TqQe0L6x-dI/AAAAAAAAABM/PPRTdmWtFYA/s1600/Untitled.png' alt='Microsoft Sharepoint Products Preparation Tool 2013' title='Microsoft Sharepoint Products Preparation Tool 2013' />Point Configuration Wizard. This account will be applied against the Share. Point Foundation Workflow Timer Service and the Share. Point Central Administration Web Site Application Pool. Please note that the server farm account is automatically added as a SQL Server login on the computer that runs SQL Server. The account is added to the following SQL Server security roles dbcreateor, securityadmin and dbowner. DOMAINspfarm. Share. Point Service Apps  This is the service application pool ID and should also be a standard domain user account. DOMAINspserviceapps. Its imperative that all of the above accounts are created and provisioned before attempting any installation of the Share. Point 2. 01. 3 bits. Please note that we have already setup SQL 2. SQL Server service account. Firstly, have your Active Directory Administrator create the above accounts in Active Directory Directory Services AD DS as standard domain users. Then navigate to each server in which you will install Share. Point 2. 01. 3 and add the DOMAINspinstall account Share. Manitowoc Parks And Rec Softball. Point Setup User Account to the Local Administrators group of that respective server. To do so Log onto the Windows 2. Server as the Domain Administrator and add the account to the Local Administrators Group via Server Manager Dashboard Tools Computer Management. Navigate to Local Users and Groups. Click on Groups Administrators. Add the DOMAINspinstall user account. We now need to provide dbcreator and securityadmin SQL roles in SQL Server 2. Launch the Microsoft SQL Server Management Studio and navigate to Security Logins. Right click and select New Login and search for the spinsall login name. Click on Server Roles and select dbcreator and securityadmin. Click Ok. Now that our service accounts are in order, we can now proceed with the actual installation. The Share. Point 2. Install. We begin the install by logging  onto the Windows 2. Share. Point 2. 01. Share. Point install service account  DOMAINspinstall. Insert the Share. Point 2. 01. 3 Preview media. Click on Install Software prerequisites note you will need to have internet access otherwise you will receive errors as it attempts to download certain bits. You will be greeted with the following Welcome Screen. Click Next. Accept the License Terms. Click Next.  The installation of the prerequisites will begin. Once complete, you will be greeted with the following screen. Click Finish and re start your server. Upon restarting and logging back in, the Share. Point 2. 01. 3 preparation tool will continue automatically. Installation complete. Click Finish. Now that we have successfully installed the Share. Point 2. 01. 3 prerequisites, we can proceed with the actual product installation. From the Share. Point 2. Install, click on Install Share. Point Server. Enter your product key the below key is the Share. Point 2. 01. 3 public preview key6. RNT8 XV2. 6M GWH3. VMGQH 9. 4MMHClick Continue. Accept the terms. Click Continue. Select Complete as the Installation Type. Click on File Location if you would like to specify an alternate installation and data location for your Share. Point 2. 01. 3 install. Select Complete then click Install Now. You will finally be greeted with the Run Configuration Wizard. Click Close to continue. You will be greeted with the all familiar welcome screen. Click Next. The usual pop up warning regarding the shut down and restarting of services will appear. Click Yes to acknowledge. Click Yes. On the connect to a server farm screen, click on create a new server farm. Click Next. Specify your configuration database settings and enter the DOMAINspfarm account credentials. Click Next. Specify the Farm Passphrase which was first introduced in Share. Point 2. 01. 0.  This passphrase is important and will be required for future installs of Share. Point 2. 01. 3 when configured in the same farm. Click Next. Here I like to specify an alternate more memorable port number. Click Next. Click Next. Now this is were I ran into an issue. The configuration process began and it failed at step 3. The error stated that the SQL Server instance does not have the required max degree of parrallelism setting of 1. Here I was scratching my head until Google came to the rescue. I came across the following MSDN article which gave me the command I needed to resolve this. We need to run the following script on our SQL 2. RECONFIGURE WITH OVERRIDE. RECONFIGURE WITH OVERRIDE. GONavigate to your SQL 2. SQL Management Studio. Open a new SQL Query Window and paste the above. That should do it You may have noticed in SQL under databases that the Share. PointConfig database had been created. We need to delete the Share. PointConfig DB otherwise we would have to specify a new name when re running the Share. Point Configuration Wizard. After deleting the Share. PointConfig DB, re run the Share. Point configuration Wizard.