.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Installing PowerPivot for sharepoint

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

Hi Guys,

Im currently in the process of setting up powerpivot for SharePoint. However after selecting (in SQL installer) Add powerpivot for SharePoint to: Existing Farm (as my farm is already created) and finally hitting the install button i get the installation is complete with the following errors:

An instance of sql server analysis services (powerpivot) does not exist in the farm

Any ideas what might be causing this?

Thanks in advance


View Complete Post

More Related Resource Links

installing powerpivot on Sharepoint backend databases



I am having Sharepoint 2010 Enterprise RTM (Farm & Complete installation) on Windows Server 2008 SP2 on Machine 1 (M1) and SQL server 2008 R2 is setup on Machine 2(M2). I have done this by giving M2 Database Server Name during Sharepoint Configuration Wizard on M1. Everything is working fine...

Now I want to install Powerpivot features and I don't know how it can be done ?

I have Run SQL server setup on M1 but this will install PowerPivot on M1 (as Powerpivot installation does not enquires about Server / Machine name).

I have Run SQL Server 2008 R2 setup on M2 which gives me the following errors:

-The User is not a farm administrator (but I am)

-PowerPivot for Sharepoint is already installed on this Computer (I have checked it hasen't)

-This option can only be used on a server that already belongs to a sharepoint server 2010 farm ( I don't know what it means... )

Can anybody helps me out ?


Installing and configuring SharePoint 2010

The following steps show how to install SharePoint 2010 on VMware workstation 7.0. Host computer used during the preparation of this walk-through was a Vista (32-bit) machine and guest machine used was VMware workstation 7.0 with Windows Server 2008 Service Pack 2 (64-bit).

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Installing Application templates on SharePoint Services 3.0 on Windows 2008 r2 x64

Hi, I know I can install this on a Windows 2003 x64, but I can't find any confirmation that this can be installed on Windows 2008 r2 x64. Can I install this on Windows 2008 r2 x64 thanks, Stjani

Installing ApplicationTemplateCore.wsp on Windows 2008 r2 x64 Sharepoint 2007

Hi, I am trying to install ApplicationTemplateCore.wsp and ApplicationTemplateCore.wsp on this server. According to installation instructions I should run stsadm from \program files (x86)\common files\microsoft shared\web server extensions\12\bin . My problem is that there is not stsadm there. Is it possible to have stsadm for x86 on Windows 2008 r2 x64? thanks, Stjani

Excel Web Part - different Powerpivot Slicer disabled tue to sharepoint users

Hello, first of all i'm new to sharepoint. I found quite similar question to mine http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9f23a77c-1527-48a8-abbc-2ccded736d9e but unfortunately it hasn't been answered. So what i have done so far: I made a Excel 2010 Powerpivot chart and Published it to sharepoint via the Powerpivot gallery. I also created a Excel web part with the spreadsheed in it. I am searching for a vba script to achieve the sharepoint username but found only some for the windows username. I also managed to disable slicers in vba. What i want to achieve: Due to the fact that the Powerpivot chart has some critical security data in it the different users should only see two different filter options (whole data and one slice for themself) So i need to disable slicers in the pivot chart tue to the sharepoint accounts. My Qestion: Is it possible? If yes, how! Any help would be appreciated. Is it possible via VBA or do i have to use Excel web scervices?  Thanks for your help :)

Error when installing the sharepoint 2010

Hi, I got the following error Configuration Failed Failed to create the configuration database An exception of type system.security.accesscontrol.privilegenotheldexception was thrown. Additional exception information: the process doesnot possess the 'SeSecurityPrivilege' privilege which is required for this operation. Thanks

Cannot fill-in Word 2003 fill-in form accessed through SharePoint (WSS 3.0) after installing Word 20

We are experiencing problems when opening a fill-in form designed in Word 2003 accessed through a SharePoint (WSS 3.0) document library after installing Word 2007.  Prior to upgrade to Word 2007, the user could open the file in read-only mode, fill-in the fields and without saving the data, print or email the completed form.  Now, in order to be able to fill-in the fields, it appears they must have SharePoint permissions set to "contribute" so that they can "Edit" the file, fill-in the fields, print or email, and then close the file and specifically indicate they do not want to save changes.  Needing advice as this changes our security in SharePoint and adds extra steps for users.  Thanks.

Installing SharePoint 2010 with SQL Server 2008 - SQL Exception - Login Failed

Hello I've been trying to install SharePoint 2010 with SQL Server 2008 in my Windows Server 2008 R2 box. I've got the same error all the times. System Specifications Windows Server 2008 R2 SQL Server 2008 with SP1 SharePoint 2010 Enterprise 6GB RAM, 320GB HDD Installation Steps I followed Installed Windows Server 2008 R2 and joined it to our domain Logged in as domain administrator Installed SQL Server 2008 Selected the Local Service account for all the SQL Server 2008 services during installation Selected Mixed mode authentication Selected 'Add Current User' in all the other installation screens Installed SQL Server 2008 SP1 Installed SharePoint 2010 Selected Farm option Selected Complete Installation Tried to run the configuration wizard and got sqlexception error - login failed But i checked that the current user (domain admin) is having all the permissions. Also added the domain admin as Security Admin and DB Creator in SQL Server instance. Any ideas?  Regards NLV Visit SharePoint User group - India

SharePoint 2010 Fails Installing On Step 5 Of The Configuration Wizard

Hello,I installed SharePoint Server 2010, and its installed properly, I installed SharePoint over Windows Server 2008 SP2 with the Standalone version (MSSQL Express) - when i run the products configuration wizard i get the following message:----------------------------------------------------------------------------------------------------------------------------------------------------------------- Failed to register SharePoint services. An exception of type System.TypeLoadException was thrown. Additional exception information: Could not load type 'Microsoft.Office.Server.Search.Administration.SearchWebServiceManagerService' from assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71E9BCE111E9429C'. System.TypeLoadException: Could not load type 'Microsoft.Office.Server.Search.Administration.SearchWebServiceManagerService' from assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71E9BCE111E9429C'. at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.RuntimeType.PrivateGetType(String typeName, Boolean t

No Standalone Option Given when Installing Sharepoint 2010 Foundation

I downloaded the Sharepoint 2010 Foundation installer ran the prerequisites installer then ran the Sharepoint Foundation install but i do not get a Standalone Option during the install only the install path then it goes strait into the configuration wizard asking for the server farm info can anyone help server 2008 DC r2 x64 on a vmware esxi box Thanks, craig

Why is it looking for: Microsoft.SharePoint.Search version when I'm installing SharePoint

I had SharePoint 2010 installed on Windows 2008R2 test box. I then upgraded it to a DC, and it broke SharePoint. In the meantime, I was asked to put SharePoint 2007 on, as a non-Microsoft SharePoint add-on that we want to test is not yet compatible with SharePoint 2007. I have removed every trace of SharePoint 2010 that I can find, but I am running into difficulties with configuraing SharePoint 2007. It installs successfully, but when it reaches task 2 of the SPTCW it fails. The error is: An exception of type System.IO.FileNotFoundException was thrown. Additional exception information: Could not load file or assembly 'Microsoft.SharePoint.Search, Version, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.   I know enough to know that it seems to be looking for SharePoint Search from 2010, but I have removed all traces of 2010. I'm guessing that there is a DLL or something that is from 2010 that hasn't been written over when installing SharePoint 2007, and it's calling for the Microaoft.SharePoint.Search.   I've been into c:\windows\assembly\GAC_MSIL and there is no evidence of a Microsoft.SharePoint.Search   I am hoping that I don't have to rebuild the server, but I'm pretty stuck now. I've spent 2 days on the whole SharePoint nightmare.

After Installing SharePoint Foundation 2010, trying to open site gives 404 error in browser


I had this as reply on a thread about migrating from WSS 3.0 to SFS 2010. But I have completed all the steps with the modified documentation, but the browser delivers an error 404 when I try to open the site I created.  Same thing happens if I go at it via https, but first I get a certificate warning error (using the IP instead of the FQDN) and then being prompted for credentials.

I am completely stumped at what else to look at.  Any help in gathering information to get help is also appreciated.

Environment:  SBS 2008, SFS 2010, SQL Express 2008.  Rest of the IIS sites continue to function normally and I can get to the management site ok.  Although after the install, I had to go into application pool and change the service account from the domain admin (it defaulted to that) to networkservice account, otherwise I got a 503.  Same thing happened on the site I created until I changed the service account.  Now just a 404.

error when installing sharepoint server 2007 on Windows server 2008 r2

I ve tried to install sharepoint server 2007 on server 64 bit with windows server 2008 r2,but it gave me compatibilty error

SharePoint VSS Writer not registering / installing properly


The SharePoint 2010 VSS Writer is not being published into the results of the vssadmin list writers and is causing Microsoft DPM from being able to protect the data.   We have tried all the standard stuff including the stsadm -o registerwsswriter, configuresharepoint -EnableSharePointProtection, re-register vss dll's, ensure spwrapper account is farm admin and local admin on the server.

I posed a question in another forumn that appears to be a SharePoint VSS issue and not a DPM issue. 


Looking at the registry, we do find the stsadm -o registerwsswriter command creates the "SharePoint Services Writer" key under HKLM\CurrentControlSet\Services\VSS\Diag\ but only creates the IDENTIFY (Enter) and IDENTIFY (Leave) DWORD values and not the GETSTATE (Enter) and GETSTATE (Leave) values that a working SharePoint server does (our non production server).

Any directions or assistance would be greatly appreciated.

We do have a case open with Microsoft for nearly 3 weeks... SharePoint team is currently reviewing still.

Installing/Configuring Exchange 2010 to Accomodate Sharepoint 2007

My company is in the process of installing Microsoft Exchange Server 2010.  I am interested in ideas of how best to configure Exchange 2010 so that SharePoint 2007 is in position to take optimal advantage of the features offered by Exchange 2010.  Any feedback on this would be helpful.  Thanks.

Installing Microsoft Office SharePoint Server 2007 on Windows 7, getting error please help

Hi all Installing Microsoft Office SharePoint Server 2007 on Windows 7 Ultimate 32-bit, getting error "Windows Server 2003 sp1" is required for this product, any help please.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend