Step by step guide on installing PowerPivot for SharePoint on a single machine
User Rating: / 167
PoorBest 
Written by Vidas Matelis   
Friday, 20 November 2009 00:10

PowerPivot for SharePoint (RTM) installation on a single machine step by step guide

Note: CTP3 installation guide is further down.

This article assumes that you want to build PowerPivot for SharePoint environment on a single machine for demo or evaluation purpose. PowerPivot for SharePoint requires that your environment would have Active Directory configured as  domain accounts are used for authentication because local machine accounts are not supported. If your demo environment already has domain setup, then you can skip few domain related steps.

Please do not use this guide if you are planning to have any real data on your computer. There is a security risk when you install SharePoint on the same machine as a Domain Controller (DC) and such setup is not recommended. Furthermore, this setups assumes that you will be using single administrator account to run SharePoint and SQL Services and such configuration should not be implemented in any real life scenario, except for software testing purposes.

So here are steps on how to setup PowerPivot for SharePoint 2010 on a single box (testing environment):

Part 1 - preparing your machine for installation

  • Install new Windows 2008R2 or Windows 2008 Server SP2, 64bit machine and apply latest security patches.
  • Check your machines name and if it is necessary rename it to your requirements.
  • In the "Server Manager" click "Add Roles" and check "Active Directory Domain Services". Click "Next". After configuration completes, choose "Start"->"Run" and enter "dcpromo.exe". This will promote your machine to domain controller. Use fully qualified domain name, for example "vidas.local". During this you will be also asked to add DNS role to your machine. You will need to choose new domain administrator password during this step.You will need to restart your machine after this step.(skip this step if you have domain setup on another machine)
  • In the "Server Manager" click "Add Features" and then select "Desktop Experience" feature. You will need this feature so you can work from server as workstation. You will need to restart your machine after setup of this feature completes.
  • In the "Server Manager" click "Configure IE ESC" to configure Internet Enhanced security. Choose "Off" for "Administrators" and "Users". When this feature is "ON", internet explorer asks you for permissions to access every website and you have to add every visited site to allowed site list. As you are building demo machine, this security setting is not necessary.

srv-config-ie-esc

Part 2 - installing SharePoint

  • Make sure that account you logon to do installation is a domain administrator. For simplicity reasons we will use that account for SharePoint and SQL Services.Again, this type of security is acceptable just for demo machines build and should not be used in any production environment.
  • Start SharePoint setup

SharePoint-setup

  • Choose option "Install software Prerequisites". Make sure that setup finished successfully.
  • Start SharePoint setup and choose option "Install SharePoint Server".
  • In the first setup window enter product key.
  • Accept licence agreement.
  • Next screen will give you option to select SharePoint file location. You will not have an option to select installation type (like "server farm" or "Standalone") because you are running setup on a machine that is also a domain controller.

SharePointFileLocation

  • After you will press "Install Now" button, SharePoint installation will begin. After installation completes, you will see window "Run configuration wizard". Un-check option "Run the SharePoint Products and Technologies Configuration Wizard now" and click close.

SharePointEnd

Part 3 - installing PowerPivot from Sharepoint

  • Now it is time to configure SharePoint for PowerPivot. This is done using SQL Server 2008R2 setup (!).
  • Start SQL Server 2008R2 setup. Choose "Installation" and then "New installation or add new features to and existing installation"
  • Go through setup till you reach screen "Setup Role"
  • In the "Setup Role" window choose "SQL Server PowerPivot for SharePoint" and for "Add PowerPivot forSharePoint to:" option choose "New server". Click Next

sql1

  • Review and then click "Next" in the "Feature Selection" window.
  • Review and then click "Next" in the "Installation Rules" window
  • Review and then click "Next" in the "Instance Configuration" window
  • In the "New SharePoint Farm Configuration" window specify
    User name: <domain name>\<userName>. For simplicity you can use user account that is currently logged on, for example "vidas\administrator"
    Password: <your password>
    Pass phrase: <your pass phrase>
    Confim: <your pass phrase>
    Leave port number generated for you

sql2-farm

 

  • Review and then click "Next" in the "Disk Space Requirements" window
  • In the "Server configuration" window specify accounts used to run Agent, SQL and SSAS services. You can use the same account that is currently logged on, for example "vidas\administrator". Click Next.

sql3-accnts

  • In the "Database Engine Configuration" window add current user (click "Add Current User") and other users (as required, click "Add...") to the "SQL Server Administrators" list. Review "Data directories" tab. Click "Next".

sql4-db-engine

  • In the "Analysis Services Configuration" window add current user (click "Add Current User") and other users (as required, click "Add...") to the "Analysis Administrators" list. Review "Data Directories" tab. Click "Next".

sql5-ssas

  • Go through the rest of the setup steps and then setup will start. It might take 30-60min for setup to complete.
  • After setup completes, test your SharePoint site. Start IE and enter url http://<YourServerName> (example: http://SharePoint). It might take few minutes (on a slowers machines even 5min) for SharePoint website to respond first time. You should see SharePoint site that looks similar to:

sharepoint-site

  • Test your SharePoint "Central Administration" site. Click on "Start" then choose menu "All Programs"->"Microsoft SharePoint 2010 Products" and then "SharePoint 2010 central administration". You should see SharePoint site that looks similar to this picture:

sharepoint-central-admin

  • Create PowerPivot workbook and to test, save it on your SharePoint site.
  • Review SharePoint logs in the folder [SystemDrive]:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\
  • Installation is done.

At this point you should be done and your PowerPivot for SharePoint environment should be ready for your testing. Enjoy!

Additional resources:

If you found this article useful - please scroll to the top and rate it (option just below article title). Every rating is very much appreciated!


PowerPivot for SharePoint installation on a single machine - November CTP (CTP3)

As Microsoft just released Office 2010 beta, SharePoint 2010 server beta and PowerPivot for SharePoint, many of you will want to test this setup in your own environment. Here you will find step by step instructions on how to build such environment.

This article assumes that you want to build PowerPivot for SharePoint environment on a single machine for demo or evaluation purpose. PowerPivot for SharePoint requires that your environment would have Active Directory configured as  domain accounts are used for authentication because local machine accounts are not supported. If your demo environment already has domain setup, then you can skip few domain related steps.

First of all I would like to point that Microsoft already has very good documentation on how to setup PowerPivot for SharePoint here. But that document describes multiple scenarios (farms, single or multiple machines, etc), so I decided describe what you need to do exactly to setup PowerPivot for SharePoint 2010 on a single box. I also included all fixes that you need to apply for November CTP (CTP3) installation.

So here are steps on how to setup PowerPivot for SharePoint 2010 on a single box (testing environment):

  • Install new Windows 2008R2 or Windows 2008 Server SP2, 64bit machine and apply latest security patches.
  • Add role "Active Directory Domain Services" and promote machine to domain controller using dcpromo.exe. During this you will be also asked to add DNS role to your machine. (skip this step if you have domain setup on another machine)
  • In your active directory create following users:
    SPAdmin - SharePoint administrator account
    SQLService - domain accounts that will be used to run SQL Server/SSAS services
    Note - you do not need to add these accounts to any groups.
  • Add Server feature "Desktop Experience" ("Server Manage"->"Features"->"Add Feature") so you can work from server as workstation.
  • Make sure that account you logon to do installation is domain administrator.
  • Start Sharepoint setup and choose option "Install software Prerequisites". Make sure that setup finished successfully. If you do not have connection to Internet, then you might need to download to your machine certain packages yourself. Here is info on how to do that.
    Note: For CTP3 if you already have Power-Shell 1.0 installed on your machine, this step will fail during PowerShell V2 (CTP3) install. You have to manually uninstall PowerShell. For Windows 2008 you can do that from "Server Manage" - choose Features then "Remove Features" and then uncheck "Windows PowerShell".
  • Install WCF hot fix.
  • If you setup domain controller on the same machine that will run SharePoint,  the following Windows PowerShell command would need to be run to enable Sandboxed Solutions.
    Note: Script was written by Jie Li and copied from here.

$acl = Get-Acl HKLM:\System\CurrentControlSet\Control\ComputerName
$person = [System.Security.Principal.NTAccount]"Users"
$access = [System.Security.AccessControl.RegistryRights]::FullControl
$inheritance = [System.Security.AccessControl.InheritanceFlags]"ContainerInherit,ObjectInherit"
$propagation = [System.Security.AccessControl.PropagationFlags]::None
$type = [System.Security.AccessControl.AccessControlType]::Allow
$rule = New-Object System.Security.AccessControl.RegistryAccessRule($person, $access,$inheritance, $propagation, $type)
$acl.AddAccessRule($rule)
Set-Acl HKLM:\System\CurrentControlSet\Control\ComputerName $acl

Here are steps on how you can run this script:

copy script to file sp.ps1
in command line enter "PowerShell"
enter "Set-executionpolicy unrestricted" (without double quotes)
enter "C:\Scripts\sp.ps1" (without double quotes)
enter "Set-executionpolicy restricted" (without double quotes)
enter "Exit" (without double quotes)

  • Start SharePoint setup.
    Note: it is very important that you choose correct setup options, otherwise you will not be able to setup PowerPivot for SharePoint in the later steps.
  • In the "Choose the Installation you want" click on "Server Farm" button. It is important that you do not click on "Standalone" button, even when you are installing standalone SharePoint server (!)
  • In the next window "Server type" choose option "Complete - Install all components. Can add servers to form a SharePoint farm".
  • After you will press "Install Now" button, SharePoint installation will begin. After installation completes, you will see window "Run configuration wizard". Un-check option "Run the SharePoint Products and Technologies Configuration Wizard now" and click close.

 

  • Now it is time to configure SharePoint for PowerPivot. This is done using SQL Server 2008R2 setup (!). You can download SQL Server 2008R2 November CTP here.
  • Start SQL Server 2008R2 setup.
  • In the "Setup Role" window choose "Analysis Services with SharePoint Integration" and for "Add Gemini service to:" option choose "New farm".

Picture 1

Analysi Services setup with PowerPivot integration

  • In the "New SharePoint Farm Configuration" window specify
    User name: <domain name>\SPAdmin (user created in previous step)
    Password: <your password>
    Pass phrase: <your pass phrase>
    Confim: <your pass phrase>
    Leave port number generated for you

Picture 2

SharePoint farm configuration

  • In the "Server configuration" \ "Specify the service accounts and collation configuration" window specify accounts used to run Agent, SQL and SSAS services. You can use for that domain accont "<domain>\SQLService" created in one of the previous step.
  • In the "Database Engine Configuration" window add current user and other users (as required) to the "SQL Server Administrators" list.
  • In the "Analysis Services Configuration" window  add current user and other users (as required) to the "Analysis Administrators" list.
  • Setup will start.
  • If your domain controller is on another machine, then you are done and you do not need to follow steps below. Just wait for setup to finish.
  • If you are running domain controller on the same machine, you are not done yet. It is very important that you monitor your setup, as you might have to do some tricks, to make it work!
  • If you are running this on virtual machine (Hype-V), then I would recommend that you create your machine snapshot just before your setup will reach half way, in case you will need this recovery point.
  • There is a know issue when you install PowerPivot on domain controller described here. Basically in the middle of the setup your service "SQL Server Analysis Services (GeminiBI)" might change logon credentials from the domain account to "Local system account". You should prepare for that and change logon credentials back to domain account as described in the post above. Monitor your setup when it reaches approximately this point:

Picture 3

PowerPivot for SharePoint intallation progress

Then refresh service list every few seconds till you see that service account changed and reset it back

Picture 4

Services list

  • After you changed service account restart service and let setup doe its job. After few minutes setup will finish.
  • You can check your new SharePoint site that has integrated PowerPivot by typing in your server name in Internet Explorer:

Picture 5

PowerPivot for SharePoint website

  • Installation is done.

Added Nov 25, 2009

After installation try to create and deploy PowerPivot to SharePoint. Check if during interaction with published PowerPivot you are getting error message:

"Excel Web Access"
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:
Sandbox

If you are getting error message above, then add your SharePoint administrator account (in our case account is <domain>\SPAdmin) to the active directory user group "Domain Admins" and restart your machine.

Added Nov 27, 2009 - Big thanks to Russell Christopher for this tip!

You might encounter issue, when you deploy PowerPivot report to PowerPivot gallery, you might see that gallery preview is not generated. When you hover over report in the gallery, you might notice following error: "An Error Occued while Capturing Snapshots for this Document".

Also, if you review [SystemDrive]:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\gemini.log file, you might notice following error text:

11/26/2009 8:08:37 PM :  VidasPPTest-2.xlsx -  is Added in  PowerPivot Gallery  located at  http://win2008r2-test1  by   VD\administrator  .  .
11/26/2009 8:08:38 PM :  VidasPPTest-2.xlsx - Refresh/Update loop succeeded! (vti_Snapshots)  .
11/26/2009 8:08:39 PM :  VidasPPTest-2.xlsx -  is Updated in  PowerPivot Gallery  located at  http://win2008r2-test1  by   VD\administrator  .  .
11/26/2009 8:08:39 PM :  VidasPPTest-2.xlsx - Pending operation detected  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx - SUCCESS: GetSnapshot self-terminated (after 298.3935967 seconds)  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx - Parsing .info file (C:\Windows\TEMP\50035e2b_9a62_483f_83c6_8f3e992f5272.info)  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx - INFO: 'http://win2008r2-test1:80' was found in a different trust zone (URLZONE_INTERNET). Attempting to remove from URLZONE_INTERNET.  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx - INFO: 'http://win2008r2-test1:80' was removed from (URLZONE_INTERNET)  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx - INFO: 'http://win2008r2-test1:80' cannot be added to the list of trusted intranet sites: -2147024890  .
11/26/2009 8:13:36 PM : ERROR: VidasPPTest-2.xlsx - INFO: System.TimeoutException: The operation has timed out.  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx -    Snapshots:(0)  .
11/26/2009 8:13:36 PM :  VidasPPTest-2.xlsx - Refresh/Update loop succeeded! (vti_Snapshots)  .
11/26/2009 8:13:37 PM :  VidasPPTest-2.xlsx -  is Lazily refreshed in  PowerPivot Gallery  located at  http://win2008r2-test1  by   VD\administrator  .  .
11/26/2009 8:13:37 PM :  VidasPPTest-2.xlsx - Refresh/Update loop succeeded! (vti_RGTrigger)  .
11/26/2009 8:13:37 PM :  VidasPPTest-2.xlsx -  is Updated in  PowerPivot Gallery  located at  http://win2008r2-test1  by   VD\administrator  .  .
11/26/2009 8:13:37 PM :  VidasPPTest-2.xlsx - Refresh/Update loop succeeded! (vti_Snapshots)  .

If you encountering this issue, you have to follow these steps:

  • Log off from your SharePoint machine
  • Login to your SharePoint machine with the SharePoint admin account. In our guide we used account <domain name>\SPAdmin
  • Start Internet Explorer and add your SharePoint website to the trusted website list.
  • Restart your machine
  • Login back to your machine with regular account and try to deploy another report to PowerPivot gallery. Now you should see new report in PowerPivot gallery preview.

Added Nov 28, 2009 - Big thanks to Mariano Teixeira Neto (Microsoft) for this fix!

After all this setup you might still experience issues with data refresh. Check your SharePoint log to see if you can find following reported error logged every minute:

EXCEPTION: System.UnauthorizedAccessException: Access to the port is denied.     at System.IO.Ports.InternalResources.WinIOError(Int32 errorCode, String str)     at System.Threading.Semaphore.OpenExisting(String name, SemaphoreRights rights)     at Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshService.Execute() 4f7eb9c8-186a-4496-a76a-93af1d275504

Also, if you will try to schedule report refresh, you will not see any errors, but your report will not be refreshed.

To fix this data refresh issue you need to addSharePoint addministrator account (in our case <domain>\SPAdmin to the user group SQLServerMSASUser$MACHINENAME$DBINSTANCE. After that restart your machine and you can schedule your PowerPivot workbook data refresh.

At this point you should be done and your PowerPivot for SharePoint environment should be ready for your testing. Enjoy!

Additional resources:

If you found this article useful - please scroll to the top and rate it (option just below article title). Every rating is very much appreciated!

  Tags: sharepoint, paper, setup, excel
Comments (30)
30 Monday, 28 April 2014 11:46
margriet@loisandclark.eu
The error "Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.*' can be solved by deploying the PowerPivot solution for the specific web application that will contain PowerPivot files.

Deploy the solution package:

1.In Central Administration, in System Settings, click Manage farm solutions.
2.Click Powerpivotwebapp.
3.Click Deploy Solution.
4.Choose the web application for which this error is occurring. If there is more than one web application, redeploy the solution for all of hem.
5.Click OK.
29 Friday, 31 December 2010 06:11
GJ Srinivas
Awesome, It just worked. I followed what you have given here.
Thanks,
GJ Srinivs
28 Monday, 18 October 2010 16:20
Frits Nagtegaal
Thank you for sharing this.

First I got the message that I had a Sharepoint Foundation Server, which is not the case. I found out that I needed the Sharepoint Enterprise version in stead of the Sharepoint Standard Version. I could upgrade this in the administration URL of Sharepoint. Now that the Installation rules were all good after the installation I got the same error as Vidas:

"load file or assembly 'Microsoft.AnalysisServices.SharePoint.Intergration, Version = 10.0.0.0, Culture=neutral. PublicKeyToken= 89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Beats me.

Any help would be highly appreciated.
27 Monday, 20 September 2010 18:53
SillyPelican
- Me Sad - What looked like a great way to provide spiffy Forecast reporting - and I'm locked out; as I can't have a domain admin account, I'm not a member of the IT team but have been doing SQL - ASP web reporting on my lab systems for years. No domain admin account / requires active directory / special SQL setup /etc = to complex for bunch of folks currently using Access and SQL for large data reporting.... = 8^(
26 Tuesday, 27 April 2010 04:11
greg kramer
If you are booting from vhd per kasper, http://tinyurl.com/2dyfnvb then I found the following to be helpful regarding wireless access:


The cause of the no wireless connection is that Windows Server 2008 and Windows Server 2008 R2 disables and turns off Wireless LAN service by default, which supports the wireless WLAN Auto Configuration service, and configures WLAN AutoConfig for automatic startup.

In order to turn on Wireless LAN and WLAN AutoConfig service in Windows Server 2008 and Windows Server 2008 R2, go to Server Manager (in Administrator Tools). Go to Features branch and click on Add Features. Click and tick the check box for Wireless LAN Service. Complete the installation wizard to install wireless support.
25 Saturday, 17 April 2010 07:30
Lee Cascio
After burning the VM one more time and following these directions very closely I got this work. Awesome directions! This really helped get through a painful process.
24 Wednesday, 13 January 2010 14:28
Vidas M.
Martin,

In my case when setup starts I saw that service account was domain account - that is what I want. Just very close to the end that account changed to local system account. So when account is still domain account, there is nothing you can change it too. But this area is quite tricky - not everybody experienced that account switch, I am not sure what causes it. In any way, I am sure this will be fixed for RTM release.
23 Wednesday, 13 January 2010 06:49
Martin
Vidas,

Thanks for the excellent manual. It installed flawlessly. I do have one remark though for this section:

..."SQL Server Analysis Services (GeminiBI)" might change logon credentials from the domain account to "Local system account"...

I didn't see it change during the setup. Because I probably wasn't patient enough I looked at the properties and changed it before the setup changed it during the installation. Maybe its a suggestion that you change the logon account as soon as the service starts, in stead of changing it when the setup reverts it to a system account.

Thanks!!!
22 Thursday, 07 January 2010 17:58
Matt
This is an awesome post. Flawless install thanks to you. Only problem I had was with the gallery previews but your solution worked a treat. Big thumbs up and thanks for this great article.

Gratefully,

Matt
21 Monday, 04 January 2010 19:49
PowerPivot-Info.com
Pedro,

Could you create new forum topic on this site and attach zipped log file that you created during error. And let me know in this forum post time when this error happen. I would like to see that error log to see if there are more log entries. Also can you include Gemini.log file to that zip file too?
There is no way to attach files to the comments on articles, so forum topic would be easiest way for that.
20 Monday, 04 January 2010 19:38
PedroVieira
Yes. I have another smaller (and less complex) Powerpivot in the same site working.
All configurations are default in Sharepoint, as instructed by this guide, except your last post that I tweaked a little performance for PowerPivot (see previous Vidas reply).
19 Monday, 04 January 2010 18:49
Vidas M.
Pedro,

Have you confirmed that your SharePoint + PowerPivot installation was a success? Are you able to browse even empty SharePoint document library?
18 Monday, 04 January 2010 18:46
PedroVieira
It was on:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\%SERVERNAME%-%DATE%-%HOUR%

Also, my file has only 4 MB.
17 Monday, 04 January 2010 18:44
PedroVieira
I think this is it:

Name=Request (GET:http://produtos:33708/Disec/_layouts/xlviewer.aspx?id=/Disec/Shared%20Documents/2010_BI.xlsx&Source=http%3A%2F%2Fprodutos%3A33708%2FDisec%2FShared%2520Documents%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1)
Site=/
ExcelWebRender.SetSPThemeingInformation: The webThemeUrl is empty. Unable to retrieve theme information from SharePoint
ExcelWebRenderer.OnLoad: Starting loading external EWR
User=LAB\Administrator
ServerSession.ExecuteWebMethodCore: sending request of type OpenWorkbook, to server=http://PRODUTOS:32843/de596a1d6ab443c8afc4f78f00e283e7/ExcelService*.asmx, session=, state id=-1, health score=0, error delta=0
MossHost.GetEndpointAddress: Server endpoint Uri: http://produtos:32843/de596a1d6ab443c8afc4f78f00e283e7/ExcelService.asmx.
WcfSendRequest: RemoteAddress: 'http://produtos:32843/de596a1d6ab443c8afc4f78f00e283e7/ExcelService.asmx' Channel: 'Microsoft.Office.Excel.Server.CalculationServer.Proxy.IExcelServiceSoap' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/OpenWorkbook' MessageId: 'urn:uuid:d158b4af-5869-4890-986a-aa44659afc03'
WcfReceiveRequest: LocalAddress: 'http://produtos.lab.internal:32843/de596a1d6ab443c8afc4f78f00e283e7/ExcelService.asmx' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/OpenWorkbook' MessageId: 'urn:uuid:d158b4af-5869-4890-986a-aa44659afc03'
ECS RequestId=320
ExcelService.LogRequest: starting request of type OpenWorkbook. Caller ip=fe80::3195:3e7e:76da:420c%10
User=0#.w|lab\administrator
SessionSite.SetSession: Setting the session for the session site. WorkbookUrl=http://produtos:33708/Disec/Shared Documents/2010_BI.xlsx SessionId=1.V22.18y7vKt3XQ+GMSj55Yucwb90.5.en-US5.en-US73.+0180#0000-02-06-02T23:59:59:0999#+0000#0000-10-06-03T23:59:59:0999#-006036.a4e59549-cc03-4e38-ac22-626674bb9be31.N
SessionManager.IncrementSessionsPerUser: There are 1 active users
SessionManager.GetSessionAndMarkUsed: Created Session id=1.V22.18y7vKt3XQ+GMSj55Yucwb90.5.en-US5.en-US73.+0180#0000-02-06-02T23:59:59:0999#+0000#0000-10-06-03T23:59:59:0999#-006036.a4e59549-cc03-4e38-ac22-626674bb9be31.N, ViewOnly=True, caller=fe80::3195:3e7e:76da:420c%10, session site count=2
Leaving Monitored Scope (EnsureListItemsData). Execution Time=15.783849623346
Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=386.075325215914
Document=http://produtos:33708/Disec/Shared%20Documents/2010_BI.xlsx
PF_CHECK_ERROR returned 'critical hresult error' 0x80004005 ; Stack Trace:NA
PF_CHECK_ERROR returned 'critical hresult error' 0x80004005 ; Stack Trace:NA
PF_CHECK_ERROR returned 'critical hresult error' 0x80004005 ; Stack Trace:NA
(0): location: (0) condition: StackTrace: at Microsoft.Office.Server.Native.dll: (sig=6c07bb41-0504-4d31-83da-11d9dbe927e7|2|microsoft.office.server.native.pdb, offset=20391) at Microsoft.Office.Server.Native.dll: (offset=208ED) at xlsrv.dll: (sig=406ddd3c-af52-4f1f-8a9f-10e49305417d|2|xlsrv.pdb, offset=4BFC80) at xlsrv.dll: (offset=744261) at xlsrv.dll: (offset=7444C1) at xlsrv.dll: (offset=17ED32) at xlsrv.dll: (offset=4C1FD7) at xlsrv.dll: (offset=4AAD04) at xlsrv.dll: (offset=487C34) at mscorwks.dll: (sig=9118f8e3-5dd9-4d2f-86f6-957055536f8a|1|mscorwks.pdb, offset=2D0D77)
Watson bucket parameters: SharePoint Server 2010, ULSShipAssert12, f6hp, 14.0.4536.0
PF_CHECK_ERROR returned 'critical hresult error' 0x80004005 ; Stack Trace:NA
Result=Id=InternalError; Microsoft.Office.Excel.Server.CalculationServer.SessionException: An error has occurred. at Microsoft.Office.Excel.Server.CalculationServer.CachedRangeXml.Microsoft.Office.Excel.Server.CalculationServer.ICachedFileProvider.SaveFile(CachedFile cachedFile) at Microsoft.Office.Excel.Server.CalculationServer.CachedFile.SaveFile(ICachedFileProvider fileProvider) at Microsoft.Office.Excel.Server.CalculationServer.LocalDiskCache.ReserveCachedFileAndMarkUsed(FileId fileId, ICachedFileProvider fileProvider, Boolean replaceExistingFile) at Microsoft.Office.Excel.Server.CalculationServer.CachedRangeXml.GetXml() at Microsoft.Office.Excel.Server.CalculationServer.UserWorkbook.GetRangeXml(Int32 stateId, VisibleSheetRange visibleSheetRangeRequest, GetRangeXmlO
16 Monday, 04 January 2010 18:32
Vidas M.
Pedro,

Please check folder:
[SystemDrive]:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\

There will be multiple files in that folder. PowerPivot related stuff will be in Gemini.log file, but there will be SharePoint log file with timestamp that will also might have explanation. SharePoint file is quite large, so it is not that easy to find that error log. So make sure you know exact error message time and then review log entries for that time.
15 Monday, 04 January 2010 18:23
PedroVieira
Thanks for your reply Vidas.

Changing those settings didnt fix this issue.
Where can I find logs?
14 Monday, 04 January 2010 16:38
Vidas M.
Pedro,

Is your workbook bigger than 50MB? By default SharePoint allows to upload maximum up to 50MB file. But you can change that:

http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/01a6e85a-3535-4a06-b402-08082be76b96

If that is not your problem, you have to check log file and see error message recorded by SharePoint at the time of publishing.
13 Monday, 04 January 2010 16:35
PedroVieira
I have built a fair complex PowerPivot App that works pretty well in Excel 2010. Most of the complex is in design/slicers changes (outside normal aggregator) and also modifications inside normal pivot tables (hidden feature?). When I upload to my Sharepoint 2010 lab VM (that is working well after your excellent guide), I can´t load that file and gives me the error:
"Excel Web Apps
An error has occurred.
Try Again"
12 Friday, 18 December 2009 23:57
David
Ran thru the entire SSAS install. Then an error at the very end:

Configuration error description: Feature definition with Id f8c51e81-0b46-4535-a3d5-244f63e1cab9 failed validation, file 'Gemini\Actions.xml', line 70, character 10: The 'CommandAction' attribute is not declared.
11 Friday, 11 December 2009 15:37
greg kramer
Vidas,

Appear to have success on the 4th try!

Simply could not have done it without you.

You rock.

Thanks,

-Greg
10 Friday, 11 December 2009 03:00
greg kramer
Thanks Vidas.

Rebuild the OS it is....then follow these instructions EXACTLY.
9 Friday, 11 December 2009 01:10
PowerPivot-Info.com
Greg,

If you still have problems, I would consider just rebuilding OS. I found that it is quite easy and quick to install Win2008 or Win2008R2. You can use evaluation edition from Microsoft website, and then extend that evaluation multiple times.
http://support.microsoft.com/kb/948472.
Usually it is more than enough for such testings.
8 Thursday, 10 December 2009 23:01
greg kramer
Vidas,

I completely uninstalled & reinstalled sql server.

Came back with an error that I'm not seeing on the reported problems page.

It's saying that the web.config is missing from the IIS Web Site.

Guess I will uninstall again.

Regards,

Greg
7 Thursday, 10 December 2009 18:27
PowerPivot-Info.com
Greg,

I don't think fact that you used your domain account instead of SPAdmin makes difference.
Check this post: http://powerpivotgeek.com/server-installation/reported-problems/, specifically "Various errors after a previous uninstall fails when running NEW FARM install again". There is workaround for your reported error mesage IF you previously uninstalled SharePoint/SSAS integration and this is your second attempt to install.

And just to clarify, when you create new user, option "change password on first login" should be unchecked.
6 Thursday, 10 December 2009 18:22
greg kramer
Vidas,

You were right (as ususal) I had unchecked the "user must change password on login".

So I was able to get by that hurdle. Thanks!

Next I was hit userpassword config issues when i tried to use your SQLService account (again went back & changed to prompt for password)

Here, perhaps I made a mistake because I just used my admin account (not SPAdmin) to specifiy the service accounts and collation config's"

After this the install continued & seemed to be going fine as I awaited the logon credentials to revert to the local system account.

However, that never happened it stayed as admin but changed to disabled (around the 40 minute mark)& i can't start or do anything with it.

Now it says that it can't "load file or assembly 'microsoft.analysisservices.hsarepoint.integration, version = 10.0.0.0 or one of its dependencies. The system cannot find the file specified.

Regards,

-Greg
5 Thursday, 10 December 2009 13:48
PowerPivot-Info.com
Greg, I would test following:
- Are you using domain account? You MUST use domain, local machine accounts are not allowed
- When you created these users, have you uncheck box "User must change password on logon"? If so, you will have problem. Try to logon using this user to your domain and see

Vidas M.
4 Thursday, 10 December 2009 04:20
greg j kramer
thanks for posting this info.

can's seem to get past the new sharepoint farm configuration (picture 2)..it says the credentials i provided for the farm account are not valid...hmm, any ideas?..headed to bed now...will take it up tomorrow.

Thanks!
3 Wednesday, 25 November 2009 02:56
Jerome
Yes, everything was installed.
I have finally solved the issue.
There is a missing step: activating the feature, creating an application in the central admin!

Now I have another access / delegation issue to solve...
2 Tuesday, 24 November 2009 23:12
Vidas M.
Are you accessing this from server or machine? If it is server OS, have you installed desktop experience? Gallery requires Silverlight, do you have it on your machine?
1 Tuesday, 24 November 2009 23:08
jerome
Great article.
But I'm suffering an error after the install.
I install SSAS into an existing farm.
I create a power pivot site
but going into the powerpivot gallery raise this error:
Could not load type 'Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView'
any idea?
 

Pyramid+PowerPivot