Welcome to EMC Consulting Blogs

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

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

Processing starts

The Installation Center window appears.

I click on Installation to switch screens

I click on “New installation …”

The Setup Support Rules window appears.

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

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

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

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

Installation proceeds

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

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

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.

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

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

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

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.

The Server Configuration screen appears.

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

The service accounts are updated.

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.

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

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

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

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

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

The Installation Progress screen appears and displays the installation progress.

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

After a long time, the installation process completes.

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.

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.

Click the Memory node.

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.

Restart SharePoint 2013 configuration

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

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

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

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

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

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]

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

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

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.

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.

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

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

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

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

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

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

A message screen appears. Click OK to continue.

Restart SharePoint 2013 configuration

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

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

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

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

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

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]

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.

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

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

The Configuring SharePoint Products screen appears.

I click [Finish] when the Configuration completes.

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

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.

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.