Having recently rebuilt a server entirely with "2008" technology I have a small problem with reporting services. When trying to look at the Reports, I received the error:
"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
I found, that even though we are not trying to look at the secure site, the certificate causes issues. For development and testing purposes I found it easiest to remove the certificate. To do this perform the following steps:
1. Open Reporting Services Configuration Manager
2. Click Web Service URL and click "Advanced"
3. Remove the SSL certificates, both for IPv4 and IPv6 and click ok, and then Apply. This will remove the SSL certificates, you should now be able to use Reporting Services 2008.
For those of you who wish to learn SQL Server 2008, The Adventure Works databases are available for download here for some of the same data we are familiar with: http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=14274
There are a number of downloads available, so choose carefully. There are 4 main versions, however I would recommend that you download the full Zipped version, which will give you all four of the AdventureWorks databases, it is around an 85mb download. If you download the MSI version, it does not install and configure the databases for you; however the files are placed here: C:\Program Files\Microsoft SQL Server\100\Tools\Samples. Once downloaded, there are a few ways to load the samples, the easiest being restoring the .BAK file to SQL, remember to do this for both DW and the OLTP AdventureWorks Databases. For the Cube, you get a project that opens in SQL Server 2008, and from my experience simply deploys (as long as you have set up security correctly).
SQL2008.AdventureWorks_DB_Scripts_v [2005|2008].[ia64.msi|x64.msi|x86.msi|zip]: T-SQL scripts and CSV files for loading all four databases in the AdventureWorks family of databases and diagrams for one year-model, either v2005 or v2008.
SQL2008.AdventureWorks_DW_BI_v[2005|2008].[ia64.msi|x64.msi|x86.msi|zip]: T-SQL scripts, CSV files and database backups for loading the AdventureWorks Data Warehouse database, diagrams and Visual Studio/BIDS projects for Analysis Services projects for business intelligence samples for one year-model, either v2005 or v2008.
SQL2008.AdventureWorks_LT_DB_v[2005|2008].[ia64.msi|x64.msi|x86.msi|zip]: T-SQL scripts and diagrams for the AdventureWorks "Lite" database for one year-model, either v2005 or v2008.
SQL2008.AdventureWorks_OLTP_DB_v[2005|2008].[ia64.msi|x64.msi|x86.msi|zip]: T-SQL scripts, CSV files and database backups for loading the AdventureWorks OLTP database and diagrams for one year-model, either v2005 or v2008.
There have been a few questions, surrounding the performance of PerformancePoint, especially with large data volumes. There are many things that can be done to improve PPS performance and Microsoft has released a very detailed white paper on large volume performance testing and detailed tuning. It includes a number of tests that can be run, and the results across a number of different server configurations. Well worth a read - can be found here:
http://go.microsoft.com/fwlink/?LinkID=100209&clcid=0x409