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

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

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

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
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

This place dead?
(more…)

Related

%d bloggers like this: