TFS2008 on Windows Server 2008 and SQL Server 2008
Today I decided to create a TFS 2008 VPC environment using Windows Server 2008 and SQL 2008.
In general I have to say that the installation went pretty smooth. I created a slipstream installer according to the instructions in the installation guide. Started with installing TFC and VS SP1 to make sure that everything was done according to instructions.
When the installation was done I configured TFS to use a FQDN according to the instructions in Buck's blog post. Then I was ready to test the installation.
I was logged on to the TFS server as TFSSetup, started Visual Studio, connected to TFS using my FQDN and selected to create a new team project. It took a little while and then the PCW ended with an error.
TF30224: Failed to retrieve projects from the report server. Please check that the SQL Server Reporting Services Web and Windows services are running and you have sufficient privileges for creating a project.
Looking at the project creation log I found the error
Exception Message: System.Web.Services.Protocols.SoapException: The permissions granted to user 'GALLIEN\TFSSetup' are insufficient for performing this operation. --->
I couldn't really figure out what I had done wrong, everything seemed to look correct. Since I was running in a VPC I had enabled the undo disk before configuring the FQDN so I decided to back the environment to that point and try if it was my configuration that caused the problem but with no luck, I still got the same error.
So after looking around a bit I realized that I didn't run VS with elevated permission when testing. That was it I was able to run PCW successfully, now I only have to redo the FQDN configuration :-)
Update:
After finalizing the installation I realized that even though reporting services was working, the reports didn't. As I found out, by reading this excellent blog post, this was because of the installation of SQL I used Network Service as service account and this was used by Analysis Services to access the SQL Server. After creating a user for Network Service and adding it to the TfsWarehouseDataReader role everything works.
