You must Sign In to post a response.
  • Category: SQL Server

    SSRS Report configuration URL Error(HTTP Error 503. The service is unavailable)

    Hi , any one have any idea on below error.

    1. after configuration SQL Server 2012, when i trying to browse report URL is displaying below error.
    HTTP Error 503. The service is unavailable.


    i have googling from long time but i don't get any proper solution for this.

    2. SQL Server 2008 R2 configuration manager report server instance is black.
    i have two instance in my PC , Sqlserver 2012 and Sqlserver 2008 R2,

    Sqlserver 2012 configuration able to configure but Sqlserver 2008 R2 not able to configure report service since "report server instance is blank"


    Thanks
    Santosh
  • #766432
    Hi,

    Check whether the reporting service is started in your machine.
    Follow the below steps to check:
    1. start---> control panel---> administrative tools--->services--->
    2. check whether the SQL server reporting service is started.

    or else

    check whether the URL and portnumber is correct in rsreportserver.config file.
    Use this below path to find the config file
    C:\Program Files\Microsoft SQL Server\MSRS11.SQLEXPRESS816\Reporting Services\ReportServer

  • #766440
    Hi Kavipriya,
    Thanks for your reply.
    i have already tried this ..report services is already started..port number i m using 80 but still it's showing same error.

    May i know is it possible to uninstall only reporting services and install again. but i don't want to uninstall database engine since i have so many Databases which i am using for different application.

    You can refer the attachment


    Thanks
    Sanosh

  • #766442
    Hi,

    As per error "No report server found", the cause of this problem is there is no reporting server was installed in your machine, if it is installed then there might be some problem with Running the server in configuration managing tool, if still you face the problem you just UnInstall the report server alone and Install it again.

    While UnInstall the SQL Server choose only reporting server, checkbox so that it will uninstall only Reporting server and try to rerun the software so that it will install as you want.

    https://msdn.microsoft.com/en-IN/library/hh479745.aspx

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #766443
    HI,
    i have checked all options while installing SQL server 2008 R2 version and after install i am able to create database but not sure why reporting server has not been installed properly, even i tried two times still getting same error.
    is it because Sql server 2012 already installed? for multiple versions?

    Thanks

  • #766445
    Hi,

    I guess there is no issues with SQL Server 2012. We can maintain multiple versions in our system, there is no problem in that. Have you uninstall the Reporting server, and Install it again?

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


  • Sign In to post your comments