Configure Report Server with SQL Server Express with Advanced Services.

I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"

When I check IIS the directories were created but the Reporting Services Configuration Manager does not see them unless I attempt to recreate them again without deleting them from IIS.

Anyone have any ideas as to this disconnect?

Thanks in advance!

By default RS is configured during installation so you shouldn't need to do any additional configuration. I'll ping the RS team to see if they have additional information about the error you're seeing.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||I have been unable in this case to allow RS to be configured during the install as selecting that option always caused an error. That error was something along the lines that it could not connect to the Report Database. The only way I could get the install to finish with no errors was to have it not configure RS.|||

This one dropped off my radar, sorry.

Were you ever able to get your Report Server running correctly. It seems that I found a similar behavior that I could only create new RS virtual directories if the folder already existed.

Regards,

Mike

|||I have having precisely the same problem. I cannot install Report Services as part of the original install of SQL Server since it has an error. So I install report services separately, but if you do that, it will not auto-configure, and when I use the config tool, I get the same error above.|||It seemed to be related to an improper installation of ASP.NET. I uninstalled ASP 2.0, then uninstalled 1.1, and reinstalled both of these and then manual configuration worked.|||

It is possible that you installed ASP.NET 2.0 before you installed IIS. The .NET Framework 2.0 has some special configurations that it does when IIS is installed that don't happen after the fact without running a special configuration file.

The alternative approach that you've found is to remove and reinstall the framework.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

No, I am 100% certain that IIS and the 1.1 framework were present before I installed 2.0. I even tried aspnet_regiis -i for both 1.1 and 2.0 and that did not help. Since I did not personally install the 1.1 framework, since both it and IIS were installed from someone elses disk image, I cannot guarantee that they were configured properly.

|||

I am having problems with Reporting Services.

I go to http://localhost/reports and get error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

In terms of configuration, I have set name of Report Server Virtual Directory to "ReportServer2", as it would not let me name it "ReportServer".

I have tried uninstalling .net framework v2 and reinstalling, but this does not help.

Any suggestions?

|||

I'm trying to manually configure my second reporting server instance. I used reports/$rserver as the virtual directory, (rserver is my instance name), and got error message:

"The virtual directory could not be created. The previously set virtual directory will still be used."

Then i used only reports as the virtual dir, the configuration wizard liked it and let me go through. But when i trid to open the URL http://localhost/reports, got the error message:

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

I verified my instance "rserver" was running and i'm sure i installed IIS before I installed SDK.Looks like some of us got the same problems here, have you figured it out yet?

By the way, i installed my only SQL server instance SQLEXPRESS and my first reporting service instance by default. They work fine.