Monday, February 11, 2008

:) Team Project Creation Failed , Not able to connect to the SQL Reporting Services

Served with this error message during creation of new Team Foundation Project inside newly created TFS...


Error
Unable to connect to the specified SQL Server Reporting Services at http://xxx.xxx.xxx.xxx:8080.


Explanation
The Project Creation Wizard was not able to connect to the SQL Server Reporting Services at http://xxx.xxx.xxx.xxx:8080. The reason for the failed connection cannot be determined at this time. Because the connection failed, the wizard was not able to complete creating the SQL Server Reporting Services site.

User Action
Contact the administrator for the SQL Server Reporting Services at http://xxx.xxx.xxx.xxx:8080 to confirm that the server is available on the network and you have sufficient privileges to create a project. Also, you might find additional helpful information in the project creation log. The log shows each action taken by the wizard at the time of the failure and may include additional details about the error.



From the luvly log file... got this...


---begin Exception entry---
Time: 2008-02-06 11:04:47Z
Module: Initializer
Event Description: TF30207: Initialization for plugin "Microsoft.ProjectCreationWizard.Reporting" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: Unable to connect to the specified SQL Server Reporting Services at http://xxx.xxx.xxx.xxx:8080.
Exception Details:
The Project Creation Wizard was not able to connect to the SQL Server Reporting Services at http://xx.xx.xx.xx:8080.
The reason for the failed connection cannot be determined at this time.
Because the connection failed, the wizard was not able to complete
creating the SQL Server Reporting Services site.
Stack Trace:
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.CheckForProjectFolder(PrivateData data, String projectName, ProjectCreationContext context)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.Initialize(ProjectCreationContext context)
at Microsoft.VisualStudio.TeamFoundation.EngineStarter.InitializePlugins(MsfTemplate template, PcwPluginCollection pluginCollection)
-- Inner Exception --
Exception Type: System.Net.WebException
Exception Message: The remote name could not be resolved: 'tfs2'
WebException: Status : NameResolutionFailure
Stack Trace:
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.TeamFoundation.Proxy.Reporting.ReportingService.ListChildren(String Item, Boolean Recursive)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.CheckForProjectFolder(PrivateData data, String projectName, ProjectCreationContext context)
-- end Inner Exception --
--- end Exception entry ---



As usual... perform some diarrhea kinda digging and searching the WWW... and lucky to stumbled here... which eventually be the 'smartest' solution....

add your new TFS ip inside hosts file (C:\WINDOWS\system32\drivers\etc\hosts)..
whalla... problem solved!! Keyword .... back to the root!! Dude!!


2 comments:

Unknown said...

Same problem here, same solution. Thanks. Cheers from Brazil!

Unknown said...

I got same error, but different resolution.

I found that my Reporting Services Configuration account is different with one that I set for TFS Reporting Service. Then I set TFSREPORTS account for Reporting Services Configuration which is the same as the TFS Reporting Service expected credential. It works :).