You might have noticed that I’ve added a new section to my blog called “Troubleshooting” (see here). I have a series of TechEd and internal presentations that I have to prepare for and I thought that sharing the information with you might be interesting. Hopefully you will find it useful. Again, as always, feedback and [...]
I have just completed the final two pages for the server installation section of the blog (see here for details). These sections cover:
(3) To install PowerPivot on a new single server with a dedicated DB server, click here. Use this document to install and configure PowerPivot for SharePoint on a single server SharePoint 2010 farm [...]
I have just updated the ‘Reported Problems’ page (http://powerpivotgeek.com/server-installation/reported-problems/) with three new CTP3 reported problems. These have all been fixed in the RTM release.
I am inspired by a recent post from a colleague about the various issues that can come up with Excel Services delegation (see a Denny Lee’s blog here: http://dennyglee.com/2009/11/18/troubleshooting-powerpivot-excel-services-connectivity/) and I wanted to take it a bit further (and maybe a bit ‘geekie’-er)
First, why is this a problem? After all, as you can see in [...]
Denny Lee and I are doing an Academy Live webcast next week on our early PowerPivot best practices. Please feel free to join us!
Registration is at: https://swrt.worktankseattle.com/webcast/3475/preview.aspx
SQL90CALT: A Preview to PowerPivot Server Best Practices
Date: December 15, 2009
Event Start Time: 8:00 AM Pacific Standard Time (UTC – 8 hours)
Duration: 1 hour
This session provides a preview to [...]
So, you’d like to see what a PowerPivot-enabled workbook likes like? Want to give it a try online using just your browser? Then today is your day. The PowerPivot demos are now ONLINE, see here: http://powerpivot.com/demo.aspx – these are all hosted, and available with just your browser. Now here is a trick that we don’t [...]
Suppose your thumbnail has gotten out of whack with your workbook. How do you regenerate it? Sure, the brute force way is to re-upload the file again, but surely there must be a geek’er way to do this. Fortunately there is: just edit one of the SharePoint properties for the file. I always select the [...]
The PowerPivot for SharePoint forum (http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/ ) has just reported several new known problems and their workarounds. I’ve summarized and restructured them a bit in my “Reported Problems” page (http://powerpivotgeek.com/server-installation/reported-problems/). Enjoy.
From time to time I hear questions and comments from folks questioning why they should purchase the server-side component for PowerPivot. After all, the client software is free (with a Office 2010 Professional license). Why spend the money to invest in the server pieces . . . And because it requires a SQL Server Enterprise [...]
If you are going to change a server’s static IP address after you have installed SharePoint 2010, please remember to reboot the server to make the new address become recognized. An ‘iisreset’ isn’t good enough. Otherwise you will lose 1/2 a day of your life trying to debug it. “When in doubt, reboot” is my [...]