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

hello, My names is Daimi from Cuba. I have a doubt. I have installed SharePoint 2016 and I can’t see the following option “configure usage and health data collection”
root: Central Administration/Monitoring…..Can you help me, please?
My email is: daimi.lamoru@seisa.cu
and my linkedin profile is
https://www.linkedin.com/in/daimi-lamor%C3%BA-marciel-4a8922106/
(more…)

Related

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

I believe this is one of the so much significant information for me. And i am satisfied reading your article. However wanna remark on few common issues, The website taste is great,postwholesale nfl jerseys the articles is in point of fact nice D.Excellent job, cheers
cheap china jerseys nfl http://www.fqmarche.qc.ca/pic/page10.html
(more…)

Related

Thanks for the good writeup. It if truth be told used to be a enjoyment account it. Glance complex to more introduced agreeable from you! However, how can we communicate?
cheap nfl jerseys usa http://www.apcpnhq.com/pic/page6.html
(more…)

Related

Hi
Awesome info thx.

Can’t find a spot to post a question here, so hope you don’t mind me emailing you.

I was wondering if you ‘de mind assisting with some PowerShell on SharePoint 2010.

We are in the process of migrating domains.
So I need an easy way to get all existing permissions on “Shared Documents” and all sub folders, ie. olddomain\john and then adding a new permission ie. newdomain\john.

So at the end of the day olddomain\john and newdomain\john both have the same access.

There is a 2-way trust btw. the domains and if I go to each folder individually I can add the newdomain\john successfully, but it’ll take me a month of Sunday to do it that way.

Would really appreciate you’re assistance.

Kind Regards
E. Gerard
(more…)

Related

%d bloggers like this: