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

I feel this is one of the so much important information for me. And i’m glad studying your article. But wanna commentary on few general issues, The web site taste is wonderful,postwholesale nfl jerseys the articles is really excellent D.Just right activity, cheers
cheap authentic nfl jerseys free shipping http://www.chorale.qc.ca/uploads/title.htm
(more…)

Related

Discover what’s the deal with ingbacks? According to Wikipedia, WP supports automatic pingbacks where all the links in a published article can be pinged when the article is published?we supply cheap nfl jerseys That explains why I get messages about new comments? when posting an edit that cross-references another post of my own. Info on trackbacks and pingbacks in WP here.
authentic nfl jerseys cheap http://www.chorale.qc.ca/uploads/title.htm
(more…)

Related

obviously like your website however you have to take a look at the spelling on several of your posts.
A number of them are rife with spelling issues and I to
find it very troublesome to tell the truth on the other hand I’ll certainly
come back again. authentic Crockett Gillmore jersey
(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

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: