SOLVED: Creating virtual directory Reports for Report Manager... Error: 2147746366.
While installing Team Foundation Server (TFS) 2008 with Service Pack 1 (SP1) I received the following error:
"C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\TFRSConfig.exe" /setup /repair /s "SERVER" /u "NT Authority\NetworkService" /buildInIdentity /l "1033" /verify /ignoreExistingIISArtifacts /instancename "MSSQLSERVER" /appPoolName "UnusedSinceThisIsSql2008WhichDoesNotUseIIS" /reportServerUri "http://SERVERNAME:80/ReportServer" /reportManagerUri "http://SERVERNAME:80/Reports" /h "SERVERNAME"
In the MSI Log file:
TFRSConfig - Team Foundation Server Reporting Services Configuration Tool
Copyright (c) Microsoft Corporation. All rights reserved.
Connecting to SQL Server Reporting Services. Please wait...
Creating application pool UnusedSinceThisIsSql2008WhichDoesNotUseIIS...
Creating virtual directory Reports for Report Manager...
Error: 2147746366.
Exception of type 'Microsoft.TeamFoundation.Admin.ReportingServices.ReportingSer
vicesWmiException' was thrown.
Configuring SQL Server Reporting Services failed.
After reading some forums I found that a solution is to edit the web bindings in the Reporting Services configuration tool. My system is installed on Windows Server 2008 Standard with Microsoft SQL Server 2008 Developer Edition.
I first slipstreamed the TFS 2008 install to SP1 by doing this:
http://davidsandor.com/blogs/tipsandtricks/archive/2008/08/15/solved-how-to-install-team-foundation-server-2008-on-windows-server-2008-with-sql-server-2008.aspx
After which I received the messy error above. I truly believe this is a MAJOR bug with the TFS 2008 and TFS 2008 SP1 installer. They do not properly configure reporting services even with a clean default install. My server was freshly installed with Server 2008 STD + SQL 2008 just for this install.
On to the solution:
- Navigate to start | All Programs | Microsoft SQL Server 2008 | Configuration Tools | Reporting Services Configuration Manager.
- Connect to the instance of reporting services. (In my case, the default MSSQLSERVER)
- Change the IP Address to All Assigned (Recommended).
- Click Apply.
- Click on the Report Manager URL section and then click Advanced.
- Select the IP Address in the list and choose edit.
- Make sure the IP Address selected in the drop down is All Assigned.
- Click OK then OK then Apply then Exit.
Restart your merged Team Foundation Server 2008 with SP1 setup and you are good to go!