Category Archives: installation

Workaround: SharePoint 2013 Preview prerequisite installer doesn’t install the Microsoft SQL Server 2008 R2 SP1 Native Client

SharePoint-2013

If you install SharePoint 2013 Preview by running the prerequisite installer (Microsoft SharePoint Products Preparation Tool) and you see this line in the log file:

Error: The tool was unable to install Microsoft SQL Server 2008 R2 SP1 Native Client.

Use these steps to work around the problem:

  • Go to http://go.microsoft.com/fwlink/p/?LinkId=262370 and manually download and install the Microsoft SQL Server 2008 R2 SP1 Native Client (1033\x64\sqlncli.msi).

    Important! Do not download and use 1033\IA64\sqlncli.msi or 1033\x86\sqlncli.msi. These versions are not supported for this preview release.

  • Run the Microsoft SharePoint Products Preparation Tool again.
Advertisements

Installing SQL SERVER 2012 (for SharePoint 2013)

SQL Server

To install SQL SERVER 2012 we are using the following Setup file:

#####_SQLServer2012EnterpriseEditionwithSP1_ServerCAL(With_#########)_x64

Right Click and Mount, Run “setup” Application file as Administrator:

Note: We are logged in as [SharePoint Admin] for all installations.

This Screen will Show up:

Microsoft SQL SERVER 2012 Installation 1

Click “Installation” on the left side, the following screen will come:

Microsoft SQL SERVER 2012 Installation 2

Click “New SQL Server stand-alone installation or add features to an existing installation”, the following screen will come:

Microsoft SQL SERVER 2012 Installation 3

Click “Show Details” to view details, Click “OK” after verifying the setup support rules. In case there is a problem resolve it and Re-run the Setup. Now the following screen appears:

Microsoft SQL SERVER 2012 Installation 4

Wait for some time, the following screen will come:

Microsoft SQL SERVER 2012 Installation 5

In the product key section, Select “Enter the Product Key” which should be 25 character key. Click next, the following screen will come:

Microsoft SQL SERVER 2012 Installation 6

In the license Terms section, Select “I accept the license terms” and Select Send feature usage data to Microsoft….. Click next, the following screen will come:

Microsoft SQL SERVER 2012 Installation 7

Click Next to “Include SQL Server product updates”:

Microsoft SQL SERVER 2012 Installation 8

After the above screen, a prompt as shown below will appear for restarting the system:

Microsoft SQL SERVER 2012 Installation 9

After restart run the setup again and reach to the below screen:

Microsoft SQL SERVER 2012 Installation 10

When the Setup Support Rules screen pops up review any errors or warnings you get. If nothing bad has happened the Next button will be available to click. Click Next to view the following screen:

Microsoft SQL SERVER 2012 Installation 11

For Setup Role select SQL Server Feature Installation and click next.

Microsoft SQL SERVER 2012 Installation 12

On the Feature Selection screen this is where you need to be smart. In order to make SharePoint run you only need to select one check box, Database Engine Services. I would highly recommend you also check Management Tools – Basic and Management Tools – Complete. Click Next to view the following screen:

Microsoft SQL SERVER 2012 Installation 13

Wait for some time, the following screen will come:

Microsoft SQL SERVER 2012 Installation 14

Now when you read all of these awesome features you might be thinking “I want to kick the tires of Reporting Services – SharePoint” or some other random feature. That is great, tire kicking is fun and important but if you are reading the blog post to get SQL Server installed correctly for SharePoint then you probably aren’t ready to start randomly installing features. Even if you were ready to install them you would still most likely come back and do them after SharePoint was up and running, not before. So let’s ignore them for now and click next.

On the Installation Rules screen SQL will make some checks. In this case my Server did not have the Microsoft .NET Features installed. You will need to manually add the feature now. While you do go ahead and leave this SQL window open.

To add the .NET Windows Server feature click on Start > All Programs > Administrative Tools > Server Manager.

From the right side of the screen click on Features.

Over on the left side of the screen click on Add Features.

Check the box for .NET Framework 3.5.1 Features.

When you check the box a window for Add Features Wizard will appear telling you the additional required roles. Click Add Required Role Services.

Click Next.

At the Web Server (IIS) screen click Next.

Accept all of the defaults and click Next.

At the Confirm Installation Selections click Install.

At the Installation Results screen make sure everything was successful and then click Close.

Jump back over to your SQL Installation Rules screen and click the Re-run button.

If the tests are Passed click Next to continue.

After Installation Rules the Following screen appears:

Microsoft SQL SERVER 2012 Installation 15

Assuming this is the only install of SQL Server on this server then you are going to want to take all of the default settings for the Instance Configuration screen, but in my Case I have updated the name to be my server, Click Next.

Microsoft SQL SERVER 2012 Installation 16

Wait for some time, the following screen will come:

Microsoft SQL SERVER 2012 Installation 17

At the Disk Space Requirements screen click next.

Microsoft SQL SERVER 2012 Installation 18

For the Server Configuration screen it is asking you what accounts you want to run SQL Server as. The only service you are worried about right now is the SQL Server Database Engine. This service should always be run as a domain account not a local account. Next to SQL Server Database engine click on MANAMA1\spadmin and a drop down arrow will appear.

Click <<Browse…>>.

Select your SQL account you want to use and click OK.

Enter the account password and keep the startup type as Automatic click next.

Microsoft SQL SERVER 2012 Installation 19

Wait for some time, the following screen will come:

Microsoft SQL SERVER 2012 Installation 20

On the Database Engine Configuration screen there are lots of changes you could make and over time you will learn about these options but for the purpose this guide you will except all of the defaults. You only need to click Add Current User and it is shown as.

Microsoft SQL SERVER 2012 Installation 21

If you were building a production capable SQL Server best practice 101 would be to store your data and log files on different volumes. By default SQL Server will store everything on the C: drive. If you want change that behavior take a gander at the Data Directories tab.

Once you are ready click next the following screen appears:

Microsoft SQL SERVER 2012 Installation 22For the Error Reporting screen select Send Windows and SQL Server Error Reports…Click next the following screen appears:

Microsoft SQL SERVER 2012 Installation 23

At the Installation Configuration Rules screen click next.

Microsoft SQL SERVER 2012 Installation 24

You are ready to Install, so click Install.

Microsoft SQL SERVER 2012 Installation 25

Wait for some time, the following screen will come:

Microsoft SQL SERVER 2012 Installation 27 After Restart

When the installation finishes you may be prompted to restart. This is not directly because of SQL Server but instead because of other recent installs you have done that you haven’t rebooted since. In my case because I added the .NET feature. When SQL is all done click close. If you have any other open windows at this point you can close them as well. You are all done.

If you got the pop up screen to do a reboot it will not automatically happen, you will need to reboot on your own.

Microsoft SQL SERVER 2012 Installation 27 After Restart

Note: The Above error is due to Installation of .Net Framework 3.5, after resolving this when you run the setup again you receive the following screen:

Microsoft SQL SERVER 2012 Installation After Installing NetFx3

Now the SQL SERVER 2012 is successfully installed.

Now do what is mention in this post: Max Degree of Parallelism for SQL SERVER 2012 (before installing Sharepoint 2013)

Now do what is mention in this post: Starting/Running SQL SERVER 2012 (SQL Permissions) for SharePoint 2013

Now you have your whole SQL Server ready, so you can install SharePoint 2013.

Installing .NET Framework 3.5 Features on Windows Server 2012 R2

Windows Server 2012 R2

Open “Server Manager” on your “Windows Server 2012 R2”:

Server Manager

Click “Add roles and features” and the following screen will come:

Add Roles and Features Wizard - Before you Begin

Click “Next” and the following screen will come:

Add Roles and Features Wizard - Select installation type

Select “Role Based”, then “Next” and the following screen will come:

Add Roles and Features Wizard - Select Destination server

Select “a server from the server pool”, then “Next” and the following screen will come:

Note: I have skipped the Server Roles as I need to install only Features here.

Installing DOTNET Framework 35 Features 1

Select “.Net Framework 3.5 Features”, then “Next” and the following screen will come:

Installing DOTNET Framework 35 Features 2

As I installed my windows via DVD so I will click the option of “Specify an alternate source path

Installing DOTNET Framework 35 Features 3

The following screen will come:

Installing DOTNET Framework 35 Features 3b

Note: here we have to specify the “sources\sxs” path from our installation device.

Installing DOTNET Framework 35 Features 4

Now after selecting the path click “Install” following screen will come:

Installing DOTNET Framework 35 Features 5

After some time the following screen will come:

Installing DOTNET Framework 35 Features 6

Finally, the Features for .Net Framework 3.5 are successfully installed.

Installing Visual Studio – Ultimate 2013 with Blend

Visual Studio 2012 - Ultimate 1

To install Visual Studio Ultimate 2013 we are using the following Setup file:

SW_DVD5_VS_Ultimate_2013_English_##_##F_X##-####5

Right Click and Mount, Run “vs_ultimate” Application file as Administrator:

This Screen will Show up:

Visual Studio 2012 - Ultimate 1

Wait for the loading then the following screen will come:

Visual Studio 2012 - Ultimate 2

Note: I have changed the Path so the my Operating Systemdrive (C:\) does not get lot of Load.

Click “I agree” and then Next, then the following screen will come:

Visual Studio 2012 - Ultimate 3 new

Note: We can select what features we need from the above section of “Optional Features to Install”.

Click “Install, then the following screen will come:

Visual Studio 2012 - Ultimate 4 new

After Installation, then the following screen will came:

Visual Studio 2012 - Ultimate Error 5

I did a restart of the Server and AGAIN run the setup of Visual Studio and only one issue remained, the screen was displayed as following :

Visual Studio 2012 - Ultimate Error 7

To resolve issue of Microsoft Web Deploy 3.0 “A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file.”

I googled and found this Microsoft Link, It will download a windows installer file “MicrosoftFixit50531” just run it as Administrator.

Over view of the Error is :

These errors occur because of a failed timestamp comparison in the installer that is caused by an improperly signed Web Deploy Package.If you receive a warning after you successfully complete the installation of Visual Studio 2012, you can fix the problem by installing Web Deploy 3.0.

I did a restart of the Server and AGAIN run the setup of Visual Studio and all issues resolved, the screen was displayed as following :

Visual Studio 2012 - Ultimate 6

Now I clicked “LAUNCH”, following screen came:

Visual Studio 2012 - Ultimate 7 a

Now I clicked “Not now, maybe later”, following screen came:

Visual Studio 2012 - Ultimate 7 b

We have multiple options for “Theme” and “Development Settings”:

Visual Studio 2012 - Ultimate 7 c

Now I clicked “Start Visual Studio”, following screen came:

Visual Studio 2012 - Ultimate 8

It takes some time and we have our Visual Studio Ultimate 2013 “Start Page

Visual Studio 2012 - Ultimate 9

If You look closer to the top right there is a Flag for the “Notification Area”.

Visual Studio 2012 - Ultimate 10

Click “Notification Area” and the following screen appers.

Now you have successfully installed “Visual Studio Ultimate 2013”. Enjoy 😀