TFS SQL Reports Red Cross issue and Project creation failed.

Question

Hi All,

Issues:
1) Seeing a Red "X" sign on "Reports" folder while seeing Team Projects tree in Team Explorer.
2) While creating project, getting the following error mesg.

TF30177: Team Project creation failed.

Error TF30004: The New Team Project Wizard encountered an unexpected error while initializing the Microsoft.ProjectCreationWizard.Reporting plug-in.

Explanation TF30171: The Microsoft.ProjectCreationWizard.Reporting plug-in used to create the new team project could not be initialized and returned the following error: TF30224: Failed to retrieve projects from the report server. Please check that the SQL Server Reporting Services Web and Windows services are running and you have sufficient privileges for creating a project..

User Action Contact your Team Foundation Server administrator.

NOTE:
I have tried the following so far but didn't get any luck in resloving the issue.
1) Re-installed VS 2008 SP1 patch - no luck, red cross is still coming up.
2) Tried the above after running devenv /ResetUserData - Same, no luck, red cross still comming.
3) Uninstall VS2008 SP1 patch (which was already installed before the "red" x issue came), then ran the 2nd bullet step + 1st bullet step - Same, no luck, red cross still
    coming.
4) Uninstalled both VS2008 SP1 and then Team explorer, then installed Team Explorer from scratch - Same saw red cross on reports. So, now its time to install VS 2008
    SP1, did the same, but NO luck again, Red cross still showing up.
5) I have checked all the necessary services from SQL/Team Foundation/IIS/HTTP/WWW PS -  (they are in running state), checked all pools in IIS are running. From
    IIS, I'm able to browse Reports/Pages/....aspx files. In IE, http://localhost , http://localhost/Reports , http://<servername>/ , http://<servername/Reports is
    working too.
6) Checkin/Checkout, build creation and Web portal/WSS are all working perfectly.
7) I have tried the following link as well to make sure i'm not using an old userid/wrong password.
    http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/69d13873-e434-4b91-8d37-571b7ab961cb/ (Comments from HUA CHEN).

8) I didn't reinstall any SP1 for TFS 2008. I just did for VS 2008 SP1 reinstallations/uninstall+installations of VS2008 SP1 and Team Exp.

So, far I have tried all the solutions that i got from MSDN, but can anybody help what I have missed in resolving this issue.

Any help will be greatly appreciated.

Now, the 2nd concern is Project creation error mesg. Well, I think, If we can resolve this Red "x" cross error mesg then that will not come too. Looks like im missing something.

Thanks-

Brgds,
Arun Sangal
303 397 6059

Answer 1

Hi ALL,

If you face the same issue and trying the above solutions didn't work at all.. i.e. reinstalling VS 2008 SP1 after installing Team Explorer or deleting user client cache OR checking if all services/app pools/websites are running.. in IIS, then your solution can be simply the following.

Go to C:\program files\Microsoft.... TFS 2008 directory \ then find where is TFSADMINUTIL.exe file.. once you reach that folder.. this utility is under Tools folder, then run this command

C:\......\....\Tools\TfsAdminUtil.exe configureconnections /view

the above command will show you some output.. in the out, search for the line for "ReportServerUri" and it's value.

If the value is "http://<servername>/reportsserver/reportservice.asmx

you are LUCKY... you found the problem.

Run the following command to resolve the issue of Red cross on reports folder and New project creation error by changing this value to: http://<servername>/reportserver/reportservice.asmx

Note: the new value only has "one" "s" character in reportserver keywork in the path.

C:\......\....\Tools\TfsAdminUtil.exe configureconnections /reportserveruri:http://<servername>/reportserver/reportservice.asmx

After doing this.. close Team explorer and clear client cache.. (Search how to clear client cache in TFS ..as it depends which OS you have, it's easy to find and do that).

Restart Team Explorer and you'll find that "No red cross on reports folder" anymore and New project creation will be fast.

Cheers and thanks to Ruidong Li in MicroSoft.

Thanks
Arun Sangal