Team Project Creation Faild- not able to connect to the SQL Reporting Services at http://192.168.0.1:8080/

Installation:

------------
SqlServer 2005 (command line install)
SharePoint Service SP1 (command line install) patched with Security Update for Windows SharePoint Services (KB887981) http://www.microsoft.com/downloads/details.aspx FamilyId=6BB93661-0CE7-46CF-B8BB-55546B58A2F2&displaylang=en
TFS Beta3, single server

Some other facts:

-----------------
Reporting Services function well at http://192.168.0.1/Reports and http://192.168.0.1/ReportServer

When I browse http://192.168.0.1:8008, I receive en error
You are not authorized to view this page
However, the information returned from http://192.168.0.1:8080/Services/v1.0/Registration.asmx seems OK.

++++++++++++++++++++++++++++++++++

Team Foundation Registration web service

The following operations are supported. For a formal definition, please review the Service Description.

GetRegistrationEntries

++++++++++++++++++++++++++++++++++

Error log that I've got during team project creation.

--------------------------------------------------
10/21/2005 2:55:16 PM | Module: Wizard | Retrieved IAuthorizationService proxy | Completion time: 0 seconds
10/21/2005 2:55:16 PM | Module: ELeadServiceMediator | Team Foundation Server proxy retrieved | Completion time: 0 seconds
10/21/2005 2:55:17 PM | Module: Wizard | TF30227: Project creation permissions retrieved | Completion time: 0,6402765 seconds
10/21/2005 2:55:17 PM | Module: ELeadServiceMediator | The template information for Team Foundation Server "http://192.168.0.1:8080/" was retrieved from the Team Foundation Server. | Completion time: 0,4528785 seconds
10/21/2005 2:55:39 PM | Module: Engine | Thread: 11 | New project will be created with the "MSF for Agile Software Development" methodology
10/21/2005 2:55:39 PM | Module: Engine | Retrieved IAuthorizationService proxy | Completion time: 0 seconds
10/21/2005 2:55:39 PM | Module: Engine | TF30227: Project creation permissions retrieved | Completion time: 0,0468438 seconds
10/21/2005 2:55:50 PM | Module: Engine | Wrote compressed process template file | Completion time: 0,1873752 seconds
10/21/2005 2:56:00 PM | Module: Engine | Extracted process template file | Completion time: 9,1969994 seconds
10/21/2005 2:56:00 PM | Module: Engine | Thread: 11 | Starting Project Creation for project "TestProject" in domain "http://192.168.0.1:8080/"
10/21/2005 2:56:00 PM | Module: Engine | The user identity information was retrieved from the Group Security Service | Completion time: 0,2029898 seconds
10/21/2005 2:56:00 PM | Module: Initializer | Thread: 11 | The New Team Project Wizard is starting to initialize the plug-ins.
10/21/2005 2:56:00 PM | Module: CssStructureUploader | Thread: 11 | Entering Initialize in CssStructureUploader
10/21/2005 2:56:00 PM | Module: CssStructureUploader | Thread: 11 | Initialize for CssStructureUploader complete
10/21/2005 2:56:00 PM | Module: Initializer | Thread: 11 | The New Team Project Wizard successfully Initialized the plug-in Microsoft.ProjectCreationWizard.Classification.
10/21/2005 2:56:00 PM | Module: Rosetta | Thread: 11 | Entering Initialize in RosettaReportUploader
---begin Exception entry---
Time: 10/21/2005 2:56:00 PM
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 Reporting Services at http://192.168.0.1:8080/.
Exception Details:
The Project Creation Wizard was not able to connect to the SQL Reporting Services at http://192.168.0.1: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 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 request failed with HTTP status 404: Not Found.
WebException: Response Status Code: NotFound
WebException: Response Status Message: Not Found
WebException: Status : ProtocolError
Stack Trace:
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   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 ---

10/21/2005 2:56:00 PM | Module: Engine | Thread: 11 | Attempting to delete MSF folder "C:\Documents and Settings\m.li\Local Settings\Temp\TPW_tmp16.tmp"
10/21/2005 2:56:01 PM | Module: Engine | Thread: 11 | The temporary folder C:\Documents and Settings\m.li\Local Settings\Temp\TPW_tmp16.tmp used to store the process template was removed.

Answer this question

Team Project Creation Faild- not able to connect to the SQL Reporting Services at http://192.168.0.1:8080/

NonGT
Today, I have re-examined the solution to this post
http://forums.microsoft.com/msdn/ShowPost.aspx PostID=107903

He says he's added an entry to the host file. I had thought this is conducted on the server machine. Now I realized that this should be done on the client. Therefore I added an entry

192.168.0.1 olymp

to the file C:\WINDOWS\system32\drivers\etc\hosts on my CLIENT machine.
This solves my problem! Finally I can create a team project. Now eager to try it....

[Note. Please ensure that you don't have an empty line after this entry. Otherwise you still got another error(like me)]
朵朵
HI,

Could you kindly tell, what you see when you navigate through the URL

http://192.168.0.1/< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

This will help to confirm that sharepoint is working properly or not.

Regards

Pramod V
pattinyl
I've upgraded the sharepoint service to service pack 2. But it doesn't help. The error remains.
Jan Ku&#269;era

Dear All!

Please Check your FireWall configuration. In my notebook , i have add the TFS Server in my Norton 2007 trusted area, and allow VS 2008 & VS 2005 visit network. Then everything are ok. I can create Project via VS 2008 on TFS2005.

Thanks!
Ariston Collander
Thanks for the reply.

The default option for "Connect Using" is what you've said. I.e. “Credentials stored securely in the report server ”

The default user name is the MyDomainName\TFSREPORTS, which I have inputted during the setup of the TFS. Although the installation guide suggests this account should not be an admin account, I grant this account access right of both builtin Admin and Domain Admin,anyway. Is there any problem with this account
Gangadhart
The sharepoint service works well. No problem at all.
ShaneC
This post
http://forums.microsoft.com/msdn/ShowPost.aspx PostID=107903
described a very similar problem that I encountered.

However, it has a different inner exception message caused by name resolution.

Exception Type: System.Net.WebException
Exception Message: The remote name could not be resolved: 'pc07'
WebException: Status : NameResolutionFailure
Dag Sanna
> This LINK talks about a similar problem.


     In this link, the error message are as follows. They are not exactly the same as those I've encountered..

    His:
          Exception Type: System.Net.WebException
          Exception Message: Unable to connect to the remote server
          WebException: Status : ConnectFailure
    Mine:
        Exception Message: The request failed with HTTP status 404: Not Found.
          WebException: Response Status Code: NotFound
          WebException: Response Status Message: Not Found
        WebException: Status : ProtocolError

> Also here is a LINK from MSDN which provide some additional troubleshooting steps.

I've read this. Probrably in my case, the error could be " A critical file is missing from the server." But what kind of file Why do I have a ProtocalError Hope a VSTS developer could read this and sched some light.
newbie730

Hi,

This LINK talks about a similar problem.

< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Also here is a LINK from MSDN which provide some additional troubleshooting steps.

Regards,

Pramod V
BlueBSH
Hi,

< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I faced a similar problem during the creation of new project. So tried the following steps and it solved the issue.
- Add TfsService and Tfsreports to the administrators group.
- Navigate to http://<YukonServer>/reports
Hope it helps

Regards

Pramod V
Team Project Creation Faild- not able to connect to the SQL Reporting Services at http://192.168.0.1:8080/

Answer this question