With the upcoming release of SQL Server 2012, the new and cooler way to connect to a PowerPivot workbook within SharePoint is to use Power View which addresses the concept of Self Service Reporting (similar to how PowerPivot addresses Self Service BI). I even have a cool YouTube video showing how to connect Power View [...]
Archive for the ‘SharePoint’ Category
How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
Posted in Analysis Services, Reporting Services, SharePoint on March 25, 2012 | Leave a Comment »
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
Posted in PowerPivot, SharePoint, tagged Active Directory, Configuration, Delegation, Excel Services, FAQ, Troubleshooting, Upgrade on April 8, 2010 | 8 Comments »
Heads up, this posting’s title was “User credentials could not be delegated and Active Directory” but I realized I needed a title that evoked my emotional state Do not fret or worry, this is not “yet another user credentials delegation” blog. After all, there are already the postings including Troubleshooting #PowerPivot Excel Services connectivity (written [...]
Update SharePoint 2010 Farm Credentials Tips
Posted in PowerPivot, SharePoint, tagged Configuration on April 8, 2010 | 4 Comments »
Within your SharePoint environment – such as your PowerPivot for SharePoint single server install – a common task that you will need to do is to update the SharePoint Farm credentials when the password changes. You may be able to do this automatically by using the new SharePoint 2010 feature to plan automatic password change. [...]
PowerPivot for SharePoint Quick tip: Don’t forget to install Desktop Experience
Posted in PowerPivot, SharePoint, tagged FAQ on February 17, 2010 | 1 Comment »
For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed. But if you are using a Windows Server OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager. [...]
Handling Cross-forest deployments
Posted in SharePoint, tagged Configuration, Domain, Forest on April 9, 2009 | Leave a Comment »
In many corporate or external-facing SharePoint deployments, it becomes necessary to develop multiple forests or domains to handle different users. A great explaination of this concept can be found in the SharePoint Team’s blog on Support for Cross-forest deployments. The basic idea here is that you have two domains, e.g. DomainA and DomainB. DomainA [...]
Handling Cross-forest deployments
Posted in SharePoint on April 8, 2009 | 100 Comments »
In many corporate or external-facing SharePoint deployments, it becomes necessary to develop multiple forests or domains to handle different users. A great explaination of this concept can be found in the SharePoint Team’s blog on Support for Cross-forest deployments. The basic idea here is that you have two domains, e.g. DomainA and DomainB. DomainA [...]
Failed to provision the SharePoint Central Administration Web Application
Posted in SharePoint, tagged Configuration on February 19, 2009 | Leave a Comment »
In this situation, I ended up getting the error message: Failed to provision the SharePoint Central Administration Web Application My setup is a Windows Server 2008 Enteprise x64 box with SQL Server 2008 – attempting to configure my recently installed SharePoint 2007. That should have done the trick but I ended up getting the [...]
Failed to provision the SharePoint Central Administration Web Application
Posted in SharePoint on February 18, 2009 | 100 Comments »
In this situation, I ended up getting the error message: Failed to provision the SharePoint Central Administration Web Application My setup is a Windows Server 2008 Enteprise x64 box with SQL Server 2008 – attempting to configure my recently installed SharePoint 2007. That should have done the trick but I ended up getting the [...]

