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
New Comments to this post are disabled

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