Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MSQL Reports Service Error installing Team Foundation Server

Posted on 2007-11-20
11
Medium Priority
?
549 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20322761
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
ID: 20323103
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
ID: 20323311
... did you create the physical path on the machine before mapping the virtual directory to it ?
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:CaLoFs79
ID: 20323345
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
ID: 20323754
... 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
 

Author Comment

by:CaLoFs79
ID: 20323903
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 2000 total points
ID: 20324005
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
ID: 20335388
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
ID: 20335395
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
ID: 31410190
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
ID: 20335997
Thanks for the feedback !
Glad I could be of any help and thanks for the grade !
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

722 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