So the fate… of the entire human race depends upon my wild guess — Doctor Gaius Baltar (Battlestar Galactica) Actually, the quote that I really wanted to say was “So the fate… of the entire PowerPivot deployment depends upon my wild a** guess?! WTF!!!” Yet, this is not the time for [...]
Posts Tagged ‘Configuration’
PowerPivot for SharePoint: Existing Farm Installation
Posted in PowerPivot, tagged Configuration, SharePoint on September 14, 2010 | 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. [...]
Ramblings about missing time … and #PowerPivot sneak peek!
Posted in PowerPivot, tagged Book, Configuration, Connectivity, Design, Excel Services, FAQ, Internals, SharePoint, Troubleshooting on April 5, 2010 | 4 Comments »
Wow, I just checked and its been more than a month since I did my last blog post! So for starters, apologies for the lack of cool PowerPivot stuff on this blog. But it’s not like I haven’t been tweeting about PowerPivot…thank goodness I can easily retweet or type 140 characters! (follow me @dennylee) But [...]
Pros/Cons of deploying #SSIS with the SQL engine server
Posted in Integration Services, tagged Configuration, Performance, Tuning on January 10, 2010 | 5 Comments »
I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL Engine Server as well. While we covered a lot in Top 10 SQL Server Integration Services Best Practices, we never really addressed this issue specifically [...]
More great PowerPivot resources!
Posted in PowerPivot, tagged Configuration, SharePoint, Video on January 5, 2010 | 1 Comment »
As you already may know, we have a couple of forums for PowerPivot at: SQL Server 2008 R2 PowerPivot for Excel SQL Server 2008 R2 PowerPivot for SharePoint Dave Wickert with his PowerPivotGeek.com site has also created two new sections: Reported Problems section which compiles the different issues concerning PowerPivot for SharePoint installations and Troubleshooting [...]
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 [...]
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 [...]

