Bing: there it is! My PPS setup problem(s) solved.
Obligatory bing plug. The name is growing on me... Link #1 in the search results was Nick Barclay’s great post on sorting out PPS setup issues with SQL Server 2008:
"System.Web.Extensions" performancepoint "configuration error" - Bing
Useful reference linkages:
- Installing and Troubleshooting M&A on Win / SQL 2008
- Install PerformancePoint Monitoring Server with SQL Server 2008 (TechNet)
- ASP.NET AJAX 1.0 (the missing piece what was causing the problem)
Neither TechNet nor Nick were 100% dead-on, but together gave me enough to get the missing AJAX bits and stopped app pools sorted out. Thanks, folks.
Note to self on install order:
- Windows Serve 2008 (x86 – if you want charting to work)
- Web Server role
- Windows Updates
- SharePoint Services 3.0 with SP1
- SQLNCLI 9.0 SP2
- SQL Server 2005 ADOMD.NET
- SQL Server 2008 Reporting Services
- ASP.NET AJAX 1.0 (setup won’t ding you for it, but it’s absolutely required)
- PerformancePoint 2007
- PerformancePoint 2007 SP2
- Configure SharePoint (with remote SQL Server 2008 databases)
- Configure PPS M&A (with remote SQL Server 2008 databases)
Also, I’m not sure why Hyper-V guests don’t like the HP NC373i Multifunction Gigabit Server Adapter, but the only way that I could get Windows Server 2008 (x86) to recognize the network adapter under Hyper-V as a guest o/s was to use the Legacy Network Adapter instead of the Network Adapter. Not sure why; it wouldn’t even show up in Device Mangler when I used the Network Adapter. The only thing I didn’t try was tracking down the drivers from HP and installing them in the guest o/s the old-fashioned way, since the Legacy Network Adapter works just fine (so far).
One more thing: Team Foundation Server 2010 Beta 1 rocks! However, it didn’t play nice with PPS and PAS, so it’ll have to be lonely over there in its own little VM.
Maybe I’ll describe my adventures with the chainsaw tomorrow...