Need Setup Help: "The ReportServerVirtualDirectory element is missing"
I am getting setup problems with Reporting Services 2005.When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?Anyway, when I browse to http://localhost/ReportServer/ I get: * The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.When I browse to http://localhost/ReportManager/ I get:An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.Anyone know what I'm doing wrong and what I can do to fix?
September 19th, 2006 6:26pm
RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc... Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration
September 19th, 2006 8:23pm
Bingo. That did it. Thanks Adam!
September 19th, 2006 10:48pm
Hi, can you help me with this? I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there. I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work. I've searched for this, but this is the only sites that appears. Can you help me? If you need something like a screen shot, just mail me! Thanks!
January 29th, 2007 5:43am
hi Abasilis. Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.
March 14th, 2007 7:42pm
Yes, you are right. I have the same problem and it is fixed now. Thanks.
April 27th, 2007 4:06am
Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine. Thanks anyway..
April 27th, 2007 9:09pm
Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config" for this line: <ReportServerVirtualDirectory>????</ReportServerVirtualDirectory> Is there no text where the ????'s are? If there is text, is it the correct name for the ReportServer virtual directory? In my case, for some reason it was empty, there was no text where the ????'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did. Good luck.
May 1st, 2007 7:48pm
DanaLive, I had the same problem and added the text as you suggested to fix the problem. I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well? Code Snippet<Configuration><UI><ReportServerUrl></ReportServerUrl><ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory><ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel></UI> Thanks, Johnny
May 22nd, 2007 10:04pm
Brilliant, thank you!
June 22nd, 2007 4:13am
This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.
July 2nd, 2007 4:15pm
Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me: Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool. This corrected the errors I was having, hope this helps.
July 3rd, 2007 5:10pm
Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e.an accountthat matches the rs service.
July 10th, 2007 1:52pm
I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck. I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.
August 1st, 2007 3:10am
Thanks DanaLive! I had also the same problem; the GUI was showing all ok but the value was missing in the file. Manual Fix did it for me also! Thanks! Daniel.
November 9th, 2007 4:41pm
I had to also edit the RSWebApplication.config file in order to get it beyond the above error. now I am getting the below dreaded error. Object reference not set to an instance of an object. Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +44 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 As you can see there appears to be a problem with my authentication. If anyone could help it would be greatly appreciated. TIA John
November 9th, 2007 9:43pm
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.Hey incase any of you cant fix up this problem using the suggestions provided by the feeds you can use the below mentioned steps, as these worked for me. browse to the specified RSReportServer.config file . rightclick>>properties go to the security tab and add a user by name <machinename>\ASPNET. provide full access rights to the user and press OK just refresh the default website and browse to the report server . there you see the report server working fine.Cheers,Chandan.
January 11th, 2008 8:27am
Thank you very much for the solution. It seems that after resolving this problem there was no error message anymore
February 28th, 2008 7:20pm
I had the same issue after I had done the following uninstalled a previous SQL and Report Server installaiton checked for and removed any latent registry settings checked for and removed any latent SQL directory folders installed SQL with reporting services ( I did note that the installation would not let me use default setting for reporting services as it had done before because the files where already in use. )That last item turned out to be the issue. IIS still had references to the Reports and ReportServer under web sites in IIS Manager. I deleted these and then the Reporting Configuration Manager worked like a charm. Then I was able to pull up what I would expect to see in the browser.
March 4th, 2008 5:10am
Thanks a Million Danalive!!!!! Spent the last two days on Server 2008 64 bit, 2005 SQL 64 bit trying to get my ReportServer/Reports HTTP page to come up (frustrating to say the least). Found the link to this page: Followed your instructions as listed Saved the file Refreshed my HTTP page BAM! Reporting services home page. Your a life saver! Thanks again! wyatt2112
March 15th, 2008 6:42pm
Great Postfixed my issue!Thanks
March 26th, 2008 3:07am
I wanted to thank TejasP, With that green check that is easy step to overlook.
April 3rd, 2008 5:01pm
Adam, I had similar problem and adding the Virtual Directory in the config file helped. Now I can get to the Home of the Virtual Directory, but I am getting; "The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version." Note that I installed SQL 2005 and then applied SP2, before configuring Reporting Services. JK
April 11th, 2008 6:04pm
This worked for me also. I used local Database Server SQL server X64 standard edition and Report Server same edition, Windows 2003 SP2 X64 Enterprise. I deployed multiple Report Servers and very often that Reporting configuration services tool did the job right.
April 15th, 2008 2:08pm
Thanks DanaLive! Worked for me as well!
April 25th, 2008 8:08pm
Lookin the RSWebApplication.config for the "<ReportServerUrl>" It will look something like this <ReportServerUrl></ReportServerUrl> Change it to <ReportServerUrl>http://machinename/reportserver</ReportServerUrl> Note: Use your machine name do not use localhost. Attempt to load the page again; if it still fails ~ run iisreset; and try again.
May 3rd, 2008 7:47pm
You may be right but in my case both are sitting on the same box and I still need to fill in the blank with the default name which is 'ReportServer': <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory> ....a buggy XML but many thanks to you guys.
May 21st, 2008 11:41pm
This solved my problem too. Config said all is well, but ReportServerVirtualDirectory element is missing appeared on the browser. The RSWebApplication.config file had<ReportServerVirtualDirectory></ReportServerVirtualDirectory> instead of <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>Thanks DanaLive
September 5th, 2008 5:43pm
Danalive,You are "The Man"
February 10th, 2009 9:12pm
This solved my problem too. Config said all is well, but ReportServerVirtualDirectory element is missing appeared on the browser. The RSWebApplication.config file had<ReportServerVirtualDirectory></ReportServerVirtualDirectory> instead of <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>Thanks DanaLive This really works.Thanks Sir.
December 8th, 2009 8:49am
You just saved me hours/days of frustration! Your fix brought up my Report Manager Home Page without issue! I can't thank you enough! State of WA IT Employee
March 31st, 2010 9:46pm
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory> that fixed my problem. Thanks!
October 30th, 2010 11:18am
DanaLive, your solution fixed my issue. Thank you.
December 21st, 2010 2:39pm
Thanks DanaLive and Johnny for further clarification. That works perfectly for me. Saved me 2 sleepless night. Thanks Psalm
June 22nd, 2011 12:13pm