stevepickard
asked on
SQL 2008 R2 Report Service error
Hi
I've been trying an in-place upgrade of SQL 2008 to R2. All went smoothly first time except for the Reporting Services which failed with an error similar to "No SSL certificate available for this site" (sorry didn't take a note of the exact phrase). Looking in IIS I noticed there was no default SSL listener and certificate on the Default site, so I added one.
Nxxt tried a repair and it fell over with TITLE: Microsoft SQL Server 2008 R2 Setup
--------------------------
The following error has occurred:
The Report Server WMI provider cannot create the virtual directory. This error occurs when you call SetVirtualDirectory and the UrlString is already reserved. To continue, clear all URL reservations by calling RemoveURL and then try again.
Not a codey type so unclear as to how I should call RemoveURL. Any help gratefully recieved
Steve
I've been trying an in-place upgrade of SQL 2008 to R2. All went smoothly first time except for the Reporting Services which failed with an error similar to "No SSL certificate available for this site" (sorry didn't take a note of the exact phrase). Looking in IIS I noticed there was no default SSL listener and certificate on the Default site, so I added one.
Nxxt tried a repair and it fell over with TITLE: Microsoft SQL Server 2008 R2 Setup
--------------------------
The following error has occurred:
The Report Server WMI provider cannot create the virtual directory. This error occurs when you call SetVirtualDirectory and the UrlString is already reserved. To continue, clear all URL reservations by calling RemoveURL and then try again.
Not a codey type so unclear as to how I should call RemoveURL. Any help gratefully recieved
Steve
ASKER
Hi wolfman
Thanks for the suggestion - unfortunately reporting services won't start so I I dont think I can use the config manager
Steve
Thanks for the suggestion - unfortunately reporting services won't start so I I dont think I can use the config manager
Steve
If you cannot get in to Reporting Services Configuration Manager then you cannot get in to safely remove the URLReservations that are blocking the upgrade.
It is recommended that you do NOT remove the URLReservations in the RSReportServer.config file because that might corrupt the reservation and leave orphan reservations in HTTP.SYS
URLReservations in the RSReportServer.config file defines HTTP access to the Report Server Web service and Report Manager for the current instance. URLs are reserved and stored in HTTP.SYS when you configure the report server.
Do not modify URL reservations in the configuration file directly. Always use the Reporting Services Configuration tool or the Report Server WMI provider to create or modify URL reservations. If you modify the values in the configuration file, you might corrupt the reservation, which will cause server errors at run time or leave orphan reservations in HTTP.SYS that are not removed if you uninstall the software.
From
RSReportServer Configuration File
http://msdn.microsoft.com/en-us/library/ms157273.aspx
The following website has a library and GUI for modifying URL reservations in HTTP.SYS but this is NOT the recommended way of removing them the recommended way is to use the Configuration Manager.
see the following website
URL Reservation Modifer
http://urlreservation.codeplex.com/
It is recommended that you do NOT remove the URLReservations in the RSReportServer.config file because that might corrupt the reservation and leave orphan reservations in HTTP.SYS
URLReservations in the RSReportServer.config file defines HTTP access to the Report Server Web service and Report Manager for the current instance. URLs are reserved and stored in HTTP.SYS when you configure the report server.
Do not modify URL reservations in the configuration file directly. Always use the Reporting Services Configuration tool or the Report Server WMI provider to create or modify URL reservations. If you modify the values in the configuration file, you might corrupt the reservation, which will cause server errors at run time or leave orphan reservations in HTTP.SYS that are not removed if you uninstall the software.
From
RSReportServer Configuration File
http://msdn.microsoft.com/en-us/library/ms157273.aspx
The following website has a library and GUI for modifying URL reservations in HTTP.SYS but this is NOT the recommended way of removing them the recommended way is to use the Configuration Manager.
see the following website
URL Reservation Modifer
http://urlreservation.codeplex.com/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Then try running the upgrade again.
Reporting Services Configuration Tool
http://msdn.microsoft.com/en-us/library/ms156305.aspx