Solved

MSQL Reports Service Error installing Team Foundation Server

Posted on 2007-11-20
11
541 Views
Last Modified: 2013-11-26
I'm installing TFS on W2k3 R2 with MSQL2005

Finishing the TFS setup, I got this message:

"Error 29112. Team Foundation Report Server Configuration: Report Server is not properly configured or the Reporting Services Web site could not be reached. Use the Report Server Configuration tool to confirm that Report Server is configured properly and that Reporting Service Web site can be founda before running the installation again. For more information see the Team Foundation Installation Guide."

Then, I go to the SQL Report Configuration page and I see the error in Web Reports Site configuration.
But trying to configuring I got this message:

"ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual directory must first be created before performing this operation.

   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)"

Any idea?  I created the Virtual Directorys but something I'm missing cause I still getting this same error trying to configure the Web Report Service.

Thanks!
0
Comment
Question by:CaLoFs79
  • 6
  • 5
11 Comments
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
Also created the application pool ?

Guess you already saw this one:
http://msdn2.microsoft.com/en-US/library/ms143736.aspx

Hope this helps ...
0
 

Author Comment

by:CaLoFs79
Comment Utility
Yup, I saw it before that. And I followed those instructions.
Yes, I created the application pool and the virtual directory, I did it twice checking the instruction but not, still getting the same error in the "Reporting Services Configuration" of the MSQL.

"A virtual directory must first be created before performing this operation."
 
:/
0
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
... did you create the physical path on the machine before mapping the virtual directory to it ?
0
 

Author Comment

by:CaLoFs79
Comment Utility
Yes, I used the default in MSQL reporting system.

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

And

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Is that ok, or maybe I'm using the wrong one :P
0
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
... shouldn't you create a virtual folder for the website ?
I checked my installation documents and found d:\websites\reportingservices ...  you've got 2 ? I only have 1 ... And those folders do exist on the drive ?
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:CaLoFs79
Comment Utility
Yes, I created them from zero.
I'm using the default website in IIS.
--
For default the MSQL setup these virtual folder in the default website, right? Or should I create them in other website? how can I check that?

In the "Reporting Services Configuration Manager" the "Report Manager Virtual Directory" and "Report Server Virtual Directory" looks fine (with the check).
Only the "Web Service Indentity" looks is disabled (with the X).
I'm using them because I found them there when I got the error.

1. I create the virtual folder
2. I set the application pool as it demands: "ReportManager" and "ReportServer"

is that Right?
0
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
Comment Utility
Yep sounds like a clean and proper setup to me ...
You did restart the webservice ... probably ten times by now :-)

... looks like you need one of the IIS experts for this one ... I'm just a simple database guy ... sorry !
0
 

Author Comment

by:CaLoFs79
Comment Utility
Well, I Found the solution.

I just deleted the "SQL web reporting services Virtual Directories" of the "Default Website" in the IIS manager and using the "Reporting Services Configuration" a create a "new" virtual directories for the server and manager options. then in the "Web Service Identity" put the new Application Pools just created before.

And that's it. It works now. Now all the blank spaces are filled and running.

Looks like a bad configuration while installing sql.

Thank you Yveau.
0
 

Author Comment

by:CaLoFs79
Comment Utility
More explained.

I clicked the "New" button, created a new virtual
directory for each and deleted the old ones in IIS Manager. I then created
new virtual directories again using the old (default) names so I could be
back to the original configuration. Then I changed the Web Service Identity
from DefaultAppPool to ReportServer and everything was fine. This assumes the
UrlRoot in rsreportserver.config is correct.

Regards,

CaLoFs
0
 

Author Closing Comment

by:CaLoFs79
Comment Utility
I found the solution by my self. but thank you very much for the help. You helped a lot looking for the right steps to take.

0
 
LVL 18

Expert Comment

by:Yveau
Comment Utility
Thanks for the feedback !
Glad I could be of any help and thanks for the grade !
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now