Solved

MSQL Reports Service Error installing Team Foundation Server

Posted on 2007-11-20
11
542 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
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
 

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

920 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

15 Experts available now in Live!

Get 1:1 Help Now