Welcome to EMC Consulting Blogs Sign in | Join | Help

Randy Rempel's Blog

I work on a lot of legacy application migrations. I'm particularly interested in how new technologies can help companies realize their business goals. I also like to keep detailed records of when I try new installations of software and applications. I find it helpful in case something goes wrong. I like to share this back with the larger community (since I often borrow from those who also shared).

SharePoint 2013 Installation: Part 2 of 2

I’m continuing from Part 1.

I am ready to install SQL Server 2008 R2. I suspect that I should really install SQL Server 2008 R2 before starting with SharePoint 2013. But I wanted to see what would happen. So now I know.

I run setup from the SQL Server ISO file

clip_image002[1]

The User Account Control window appears. I click [Yes] to continue.

clip_image003[1]

Processing starts

clip_image004[1]

The Installation Center window appears.

clip_image006

I click on Installation to switch screens

clip_image008

I click on “New installation …”

clip_image004[2]

The Setup Support Rules window appears.

clip_image010

All operations passed. I click OK to continue. More processing …

clip_image004[3]

The Product Key window appears. I click [Next] to continue.

clip_image012

The License Terms window appears. I click on “I accept the license terms” and click [Next] to continue.

clip_image014[1]

The Setup Support Files screen appears. I click [Install] to continue.

clip_image016[1]

Installation proceeds

clip_image017

clip_image004[4]

The Setup Support Rules screen appears. I have one warning for Computer Domain Controller.

clip_image019

I click on the Warning and it displays. I click OK to continue.

clip_image020

I don’t have another computer to install a separate domain controller and/or a separate SQL Server. I know that some day I will have several VMs running all of this software properly; but not today.

I click [Next] to continue.

The Setup Role screen appears. I select “All Features With Defaults” and click [Next] to continue.

clip_image022

The Feature Selection screen appears. I do not change any settings and I click [Next] to continue.

clip_image024

The Installation Rules screen appears. I click [Next] to continue.

clip_image026

The Instance Configuration screen appears. I click [Next] to continue.

clip_image028

The Disk Space Requirements screen appears. I am a bit concerned about running low on disk space. I have 23GB of free disk space on the hard drive. I click [Next] to continue.

clip_image030

The Server Configuration screen appears.

clip_image032

I click on [Use the same account for all SQL Server services]. I click OK to continue.

clip_image033

The service accounts are updated.

clip_image034

I click [Next] to continue. The Database Engine Configuration screen appears. I add the sqlSvcAcc user account as an administrator. I really should not have the spAdmin listed as an administrator; but I just need things to work. I click [Next] to continue.

clip_image036

The Analysis Services Configuration screen appears. I add both users as administrators. I click [Next] to continue.

clip_image038

The Reporting Services Configuration screen appears. I select “Install the SharePoint integrated mode default configuration”. I click [Next] to continue.

clip_image040

The Error Reporting screen appears. I click [Next] to continue.

clip_image042

The Installation Configuration Rules screen appears. I click [Next] to continue.

clip_image044

The Ready to Install screen appears. I click [Install] to continue.

clip_image046

The Installation Progress screen appears and displays the installation progress.

clip_image048

Windows Activation ran to verify that my copy of Windows is genuine.

clip_image049

After a long time, the installation process completes.

clip_image051

I click on the hyperlink for the Summary log file. I note the following:

INSTANCEDIR: C:\Program Files\Microsoft SQL Server\

INSTANCEID: MSSQLSERVER

INSTANCENAME: MSSQLSERVER

ISSVCACCOUNT: SYNCHRONICITY\sqlSvcAcc

I close the log file. I click [Close] to continue. The SQL Server Installation Center screen appears. I close the screen.

clip_image053

How to restrict maximum SQL server memory

http://msdn.microsoft.com/en-us/library/ms178067.aspx

I know that I don’t have enough memory to run everything. I feel as though I should put a cap on SQL Server for this VM. Ideally, I should let it run on its own VM with a more powerful physical workstation. I would never do this setup in production. Never! However, I do know that SQL Server 2008 can run in a VM. EMC proved it quite successfully at the last SharePoint conference.

Run SQL Server Management Studio.

In Object Explorer, right-click a server and select Properties.

clip_image054

Click the Memory node.

clip_image055

Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory. I set 1024 for maximum server memory. Click OK to continue.

clip_image057

Restart SharePoint 2013 configuration

I start the configuration process again by clicking on “SharePoint 2013 Products Configuration Wizard” in the Start menu.

clip_image058

I click [Yes] in the User Account Control window.

clip_image059

The SharePoint Products Configuration Wizard screen appears. Click [Next] to continue.

clip_image060

A warning message appears. Click [Yes] to continue.

clip_image061

The Connect to a server farm screen is displayed. I select “Create a new server farm” and click [Next] to continue.

clip_image062

The Specify Configuration Database Settings screen is displayed. Now I will see if I successfully installed and configured SQL Server 2008 R2.

I enter the values below and click [Next]

Database server

MSSQLSERVER

Database name

SharePoint_Config

Username

SYNCHRONICITY\sqlSvcAcc

Password

pass@word1

clip_image063

Do I have a connection problem? I see another error message. I click OK to close the message.

clip_image064

I start up SQL Server Management Studio. The Connect to Server screen appears.

clip_image065

The screen displays the server name. I copy it and paste the value into the Specify Configuration Database Settings screen. Click [Next] to continue.

Another warning message appears. Click OK to continue.

clip_image066

Close SQL Server Management Studio.

Close the SharePoint Product Configuration Wizard.

No surprise here. I did not install service pack 1 yet.

Download and run Service Pack 1 for SQL Server 2008 R2

Note: Cannot use SQL Server 2008 SP1! Must use R2 SP1!

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=26727

The SQL Server 2008 R2 update screen appears. Click [Next] to continue.

clip_image068

The License Terms screen appears. Click on “I accept the license terms” and click [Next] to continue.

clip_image070

The Select Features screen appears. Click [Next] to continue.

clip_image072

The Check Files in Use screen appears. Click [Next] to continue.

clip_image074

The Ready to update screen appears. Click [Update] to continue.

clip_image076

The Update Progress screen appears. Click [Next] when it completes processing.

clip_image078

clip_image079

clip_image080

clip_image081

The Complete screen appears. Click [Close] to continue.

clip_image083

A message screen appears. Click OK to continue.

clip_image084

Restart SharePoint 2013 configuration

I start the configuration process again by clicking on “SharePoint 2013 Products Configuration Wizard” in the Start menu.

clip_image058[1]

I click [Yes] in the User Account Control window.

clip_image059[1]

The SharePoint Products Configuration Wizard screen appears. Click [Next] to continue.

clip_image060[1]

A warning message appears. Click [Yes] to continue.

clip_image061[1]

The Connect to a server farm screen is displayed. I select “Create a new server farm” and click [Next] to continue.

clip_image062[1]

The Specify Configuration Database Settings screen is displayed. Now I will see if I successfully installed and configured SQL Server 2008 R2 Service Pack 1.

I enter the values below and click [Next]

Database server

WIN-1J47IDE9JQG

Database name

SharePoint_Config

Username

SYNCHRONICITY\sqlSvcAcc

Password

pass@word1

clip_image085

Yes! I made it to the next screen. The Specify Farm Security Settings screen appears. I enter “pass@word1” as the passphrase. Click [Next] to continue.

clip_image086

The Configure SharePoint Central Administration Web Application screen appears. I make no changes to the settings and click [Next]

clip_image087

The Completing screen appears and I click [Next] to continue.

clip_image088

The Configuring SharePoint Products screen appears.

clip_image089

I click [Finish] when the Configuration completes.

clip_image090

The web browser opens with the Central Administration URL. I click “No” and click OK. Maybe I participate another day?

clip_image092

I check the Resource Monitor to see how my VM is doing for memory. Not too bad for now. But it’s not really processing anything significant.

clip_image094

I will stop here as the installation is complete. I need to spend some time researching what to configure. I also need to research how to upgrade from SharePoint 2010 to SharePoint 2013.

I realize that this was quite a lot of detail on installing SharePoint 2013. I know that I could have shortened it to show how the install should be done properly at each step. Maybe I will post a clean blog on the right way to do it yet. But like I said at the beginning, I wanted to learn by doing.

Published Friday, August 03, 2012 2:53 PM by rhrempel

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

BAZ said:

thank you for this information....

July 8, 2013 2:36 PM
 

Asif said:

nice stuff...i had done exactly the same...i am not been able to run the reporting server on the same machine that contains sp 2013.

please write it abt reporting services on the same machine that contains sp 2013?

January 8, 2014 5:52 PM
 

John Admin said:

This is a bad article and a terrible setup - NOBODY should set up accounts this way, and NOBODY should use a domain controller like this.

You do newbies a real *disservice* posting a crappy procedure like this :(

January 28, 2014 2:11 PM
 

Loll said:

John the EMC blog Admin post crappy comment.. good blog admin loll John is crappy. rhrempel make a good move to DELL ;)

February 9, 2014 6:53 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About rhrempel

I have worked with Microsoft and IBM technologies for 20 years. I look for ways to keep things simple for business users. I like to see the value in making changes and help projects be successful. I really believe in clear and consistent communication as part of any planning and implementation. (so I have a lot of details and screenshots in my blogs) I left EMC Consulting in July, 2013 to join Dell. LinkedIn: http://www.linkedin.com/in/randyrempel/ Twitter: @rhrempel Migration Blog: http://rhrempel.wordpress.com/
Powered by Community Server (Personal Edition), by Telligent Systems