Unable to add new SQL feature from original media after installing SP1

by Andrew Toh on October 13, 2011 in Administration

Problem

The SQL Database server was updated to SP1 before PowerPivot was installed using the original (pre-SP1) media. This resulted in the installer failing saying that the version of sqlncli.msi (SQL Server 2008 R2 Native Client) on the installer was not correct.

Solution

Download Service Pack 1 for SQL Server 2008 R2 if you haven’t already.

http://www.microsoft.com/download/en/details.aspx?id=26727

Extract the contents of the Service Pack to a folder by running the following command in command prompt.

<Name of Service Pack file>.exe /x:<drive>:\<folder to extract to>

Run the command:

Setup.exe /PCUSource=<path to SP1 folder>

This will slipstream the SP1 files during the installation.

For more information, see:

http://msdn.microsoft.com/en-us/library/dd638062.aspx#Slipstream

Related

No comments yet.

Leave a Reply

Feedback

Hi Andrew,

I have read your article http://www.mysharepointadventures.com/2012/01/user-profile-service-stuck-on-starting/

i cant leave a comment there so i m sending you this email.

I have typed stop-spserviceinstance | where { $_.typename -eq “user profile synchronization service” }
but then it askes for identity?
What identity should i put there?

Thanks a lot in advance
(more…)

Related

Dear Andrew,

I hope you are doing well!

I am working in Stellar Data Recovery, and we have a SQL database Repair software that repairs corrupted MDF and NDF files. The software name is Stellar Phoenix SQL Database Repair, and it supports MS SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2008*64, 2008 Express, 2005, 2005*64, Express, 2000, 2000*64, 7.0 and mixed formats. You can read more about this software from here: https://www.stellarinfo.com/sql-recovery.php

It would be a pleasure if you review our software. To complete the review, I will provide all the information with the product license key.

It will be more helpful if you publish it on your blog. I will also share that review on our social channels.

Waiting for your reply.

Best Regards,
Priyanka Chouhan
Business Executive – B2B
Stellar Data Recovery
Phone: +91 124 4326700
(more…)

Related

Hi Andrew,
I saw your post on using PowerShell to trigger a workflow. I tried to leave a comment there, but couldn’t because there was no Capta box for me to enter anything in.

Here’s my question: The script seems to be exactly what I’m looking for, but I’m a bit confused by one of the comment lines and one of the variable names. Specifically, “Workflows to Remove” and $listToCancel. They sound ominous, and I’m a little hesitant to try the script. Can you please provide me with some guidance?
Thanks.
Robert
(more…)

Related

Hi..
I’m looking for the following :

1. SharePoint 2010 Discussion board i need number of views for per thread.
2. SharePoint 2010 Discussion board Like and Dislike – same concept like FaceBook.

I appreciate if you can help in this
(more…)

Related

Hi Andrew,

I am writing on behalf of Stellar Data Recovery.

I stumbled upon your website through Google Search and found quite a bit of useful information. Some of information published on your site gives a deep insight about the product. Encompassing the detailed feature-set and evaluating the products on the grounds of sheer relevancy, your informations are trusted by a vast audience.

We would like to introduce our company Stellar Data Recovery established since 1993. We have around 2 million satisfied customers across 163 countries. Stellar has a Microsoft Gold ISV status and a leading data recovery company. Our products are trusted globally by corporate and home users.

Our product “Stellar Phoenix SharePoint Server Recovery” uses powerful algorithms to scan & repair corrupt SharePoint database. It supports MS SharePoint 2010 & 2007.

We would appreciate if you can have a look at our product. For a fair competency test of the product, we would gladly facilitate a product license key for you. Detailed information of the product is available at:
http://www.stellarinfo.com/database-recovery/sharepoint-recovery/sharepoint-server-recovery.php

Thanks & Regards,
Jyoti Prakash
(more…)

Related

%d bloggers like this: