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

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 athttp://192.168.0.1/Reports andhttp://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 fromhttp://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.

[6000 byte] By [Li.Ming.Net] at [2007-12-17]
# 1
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

Li.Ming.Net at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 2
I've upgraded the sharepoint service to service pack 2. But it doesn't help. The error remains.
Li.Ming.Net at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 3

Hi,

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
    • Click on TFSreportsDS
    • In the “Connect Using” Section , selectCredentials stored securely in the report server ”.
    • Provide the credentials of “SA” in the User Name and Password textboxes and click “Apply”.
    • Go back to the main page i.e. http://<YukonServer>/reports and click on “TfsOlapReportDS” and repeat the same steps.

Hope it helps

Regards

Pramod V

PramodV at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 4
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?

Li.Ming.Net at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 5

HI,

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

http://192.168.0.1/

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

Regards

Pramod V

PramodV at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 6
The sharepoint service works well. No problem at all.
Li.Ming.Net at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 7

Hi,

This LINK talks about a similar problem.

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

Regards,

Pramod V

PramodV at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 8

> 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.

Li.Ming.Net at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 9
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)]

Li.Ming.Net at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 10

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!

jialin at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...

Visual Studio Team System

Site Classified