Cannot create a new project in TFS - reporting services problem
I tried to create a new TFS team project today and got an error that the TFS server could not access the SQL Reporting Services server. I then checked I could access http://myserver/reports and this also failed. On looking in the event log I saw a number of EventID 107 ‘cannot connect to the report server database’ Now I was unsure what could have caused this, it was working last time I created a project! So check the update log on the server and found the only patches that had been applied since I last created a project, and that seemed plausible, were Visual Studio 2005 SP1 (which I thought was already on, but maybe it was just VS TFS SP1) and SQL 2005 SP2. ...