08.10
Just hit a real snaffu on get our new dev server up and running. For some reason SQL Reporting Services are not part of SQL 2008 WorkGroups. However, in theory we should be able to do an in place upgrade to another SQL edition. It has only took about 2 hrs to find out why, but hey least know I know.
the inital probelm appear using the TFS Advance configutation Wizard dropping out with
[code]
Error [ Reporting ] TF255344: Either a connection could not be made to the server that is running SQL Server Analysis Services, or the service is not running. For more information, review the following exception message: Error encountered when creating connection to Analysis Services. Contact your Team Foundation Server administrator..Error [ Reporting ] TF255275: The following Web service for SQL Server Reporting Services could not be accessed: http://exsdev/ReportServer/ReportService2005.asmx.
[/code]
but after some research it actual turned out the be that SQL 2008 RC WorkGroups just does support this. It a bit dumb in my option not to just ship this, and it probably nested away somewhere.
Anyhow, some useful links
SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010
Troubleshooting Team Foundation Server 2010 Beta 1 error <- useful if outdate, but it show how to recreate reports db
Using Business Connectivity Services in SharePoint 2010 <- nice example with a custom customer list with twitter integration and deployment to outlook
[Update]
Only ISO of SQL 2008 I had was developer, so upgrade/downgrade policy was not a valid scenario. Option was to download another ISO from MSDN
MS SQL Version and Edition Upgrades
[Update]
2 hours to find the bug. 5 mins to upgrade 