Anything wrong with the config or not?
Hi, I've setup SS2012 in Win 2008 server but when I go to the reports of Sql server like https://WIN-BVDIC8GIAHI/reports I've got this. Why? Server Error in Application "DEFAULT WEB SITE" Internet Information Services 7.5 Error Summary HTTP Error 404.0 - Not Found The resource you are looking for has been removed, had its name changed, or is temporarily unavailable. Detailed Error Information Module IIS Web Core Notification MapRequestHandler Handler StaticFile Error Code 0x80070002 Requested URL https://win-bvdic8giahi:443/reports Physical Path C:\inetpub\wwwroot\reports Logon Method Anonymous Logon User Anonymous Most likely causes:The directory or file specified does not exist on the Web server. The URL contains a typographical error. A custom filter or module, such as URLScan, restricts access to the file. Things you can try:Create the content on the Web server. Review the browser URL. Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here. Links and More Information This error means that the file or directory does not exist on the server. Create the file or directory and try the request again. View more information Many Thanks & Best Regards, Hua Min
October 3rd, 2012 12:27am

Internet Information Services 7.5 Error Summary HTTP Error 404.0 - Not Found Hello Hua Min, Since SQL Server 2008 SSRS don't utilize IIS, it has it's own HTTP.SYS, therefore you shouldn't get an error message from IIS. For me it seems you haven't installed SSRS (correctly). Please check in Windows Service Manager (services.msc) if the service "SQL Server Reporting Services (InstanceName)" is running and check with start menu entry "Microsoft SQL Server 2012" => "Configuration Tools" => "Reporting Service Configuration Manager" if you can connect to SSRS and everything is setup well.Olaf Helper Blog Xing
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2012 1:19am

Thanks. Yes, "ReportServer$SS2012" is started and I can connect to SSRS by "Microsoft SQL Server 2012" => "Configuration Tools" => "Reporting Service Configuration Manager" as well.Many Thanks & Best Regards, Hua Min
October 3rd, 2012 1:34am

Have you configured reporting services after the installation? If not you have configure your reporting service to work properly, check out the links below for configuring it http://sql-articles.com/articles/dba/ten-minutes-to-configure-reporting-services-2008/ http://sql-articles.com/articles/dba/configuring-sql-server-reporting-services/Mark as ANSWER if I helped you today :-) www.sql-articles.com
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2012 1:56am

Thanks. I can connect to Config manager. See this How can I start Config wizard? Many Thanks & Best Regards, Hua Min
October 3rd, 2012 2:24am

Any advice to this? Moderator: could you please move this thread to one of these subforums? http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/threads http://social.technet.microsoft.com/Forums/en-US/sqltools/threads as I have Technet subscription only and I don't have MSDN subscription. Many Thanks & Best Regards, Hua Min
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2012 9:57pm

Hello Hua Min, From some other post of you I remind you uses a named SQL Server instance "SS2012", right? Is this the SSRS of the named instance? If so you have to add the name of the instance to the URL for Report Manager, like: https://WIN-BVDIC8GIAHI/reports_SS2012Olaf Helper Blog Xing
October 4th, 2012 2:24am

Good day Olaf, I have tried to go to this https://WIN-BVDIC8GIAHI/reports_SS2012 But I did get these Server Error in Application "DEFAULT WEB SITE" Internet Information Services 7.5 Error Summary HTTP Error 404.0 - Not Found The resource you are looking for has been removed, had its name changed, or is temporarily unavailable. Detailed Error Information Module IIS Web Core Notification MapRequestHandler Handler StaticFile Error Code 0x80070002 Requested URL https://win-bvdic8giahi:443/reports_SS2012 Physical Path C:\inetpub\wwwroot\reports_SS2012 Logon Method Anonymous Logon User Anonymous Most likely causes:The directory or file specified does not exist on the Web server. The URL contains a typographical error. A custom filter or module, such as URLScan, restricts access to the file. Things you can try:Create the content on the Web server. Review the browser URL. Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here. Links and More Information This error means that the file or directory does not exist on the server. Create the file or directory and try the request again. View more information Many Thanks & Best Regards, Hua Min
Free Windows Admin Tool Kit Click here and download it now
October 4th, 2012 2:45am

In "Reporting Services Configuration Manager" on tab "Report Manager URL" there is a link to the RM side; have you clicked on it. I wonder about the report IP port 443, because http goes over 80 and https over 8080.Olaf Helper Blog Xing
October 4th, 2012 5:39am

Do you mean I can try http instead? By that I also have got one security issue. This is why I did try https.Many Thanks & Best Regards, Hua Min
Free Windows Admin Tool Kit Click here and download it now
October 4th, 2012 5:40am

What for a security issue? Do you get a login prompt?Olaf Helper Blog Xing
October 4th, 2012 6:08am

No, it does disallow it and I've got some errors to use http. Many Thanks & Best Regards, Hua Min
Free Windows Admin Tool Kit Click here and download it now
October 4th, 2012 6:09am

Hi HuaMin, From your description, you have configured the Reporting Services to use HTTP SSL connections to a report server. In this condition, we must modify the hostname in the report server URL to a fully qualified domain name of the server. For example, the two URLs below use the HTTP connection and HTTPS connection respectively: http://win-bvdic8giahi:80/reports_2012 http://win-bvdic8giahi.AdventureWorks.com:443/reports_2012 So, please make sure you have configured the HTTPS URLs in the Reporting Services Configuration Manager. For more information, please see: URLs in Configuration FilesConfigure SSL Connections on a Native Mode Report Server If the SSL connections have been configured properly and the issue persits, please try to edit the RSReportServer.config manually to set the UrlRoot to the fully qualified report server URL (not report manager URL). The RSReportServer.config file is located at the <drive>:\Program Files\Microsoft SQL Server\MSRS11.<instance name>\Reporting Services\ReportServer folder. Please make sure to back up the config file before modifying it. Hope this helps. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support
October 9th, 2012 10:04am

Thanks. It has been resolved by this. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7c735c1c-89fc-4dda-aa08-681c58dc7605Many Thanks & Best Regards, Hua Min
Free Windows Admin Tool Kit Click here and download it now
October 9th, 2012 10:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics