locked
Unable to configure SSRS RRS feed

  • Question

  • Please help ASAP,

    once I installed ssrs on a separate server I was configuring it and on the web url once I selected the certs and put the port number I'm getting the below error when I hit apply, please advise, thank  you.

    configmanager!DefaultDomain!f38!10/27/2017-19:13:29:: e ERROR: Configuration file element UrlReservation has a invalid VirtualRoot. It will be ignored.
    configmanager!DefaultDomain!f38!10/27/2017-19:13:29:: e ERROR: Configuration file element UrlReservation has a invalid VirtualRoot. It will be ignored.

    configmanager!DefaultDomain!f38!10/27/2017-19:13:29:: e ERROR: Failed to get url configuration section.
    configmanager!DefaultDomain!f38!10/27/2017-19:13:29:: e ERROR: Failed to get url configuration section.

    library!DefaultDomain!f38!10/27/2017-19:13:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
    servicecontroller!DefaultDomain!f38!10/27/2017-19:13:30:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

    library!WindowsService_0!f38!10/27/2017-19:13:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
    servicecontroller!WindowsService_0!f38!10/27/2017-19:13:42:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.


    library!WindowsService_0!2a8!10/27/2017-19:13:44:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
    library!WindowsService_0!2a8!10/27/2017-19:13:44:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
    library!WindowsService_0!2a8!10/27/2017-19:13:44:: e ERROR: ServiceStartThread: Attempting to start service again...


    rshost!rshost!cc!10/27/2017-19:13:44:: w WARN: Endpoint 2 is enabled but no url is registered for vdir=, pdir=D:\Program Files\Microsoft SQL Server\XXXXXXXXXXXX\Reporting Services\ReportServer.
    rshost!rshost!cc!10/27/2017-19:13:44:: w WARN: Endpoint 3 is enabled but no url is registered for vdir=, pdir=D:\Program Files\Microsoft SQL Server\XXXXXXXXXXXXX\Reporting Services\ReportManager.
    rshost!rshost!cc!10/27/2017-19:13:44:: i INFO: Endpoint 4 is disabled and no url is registered vdir=, pdir=D:\Program Files\Microsoft SQL Server\XXXXXXXXXXXXXXXXXX\Reporting Services\ReportServer\ReportBuilder.


    • Edited by DataNerdE Monday, October 30, 2017 8:36 PM
    Monday, October 30, 2017 8:34 PM

Answers

  • Hi DataNerdE,

    According to your picture, it seems that when you install the SSRS, you choose only install mode, right? 

    If so, you need to check the following conditions:

    1. You must be a member of the local Administrators group on the report server computer.
    2. If IIS is installed on the same computer, check the names of virtual directories on any Web site that uses port 80. If you see any virtual directories that use the default Reporting Services virtual directory names (that is, "Reports" and "ReportServer"), choose different virtual directory names for the Reporting Services URLs that you configure.
    3. You must use the Reporting Services Configuration tool to configure the URL
    4. Choose a time that has low report activity. 

    You could refer to Configure a URL (SSRS Configuration Manager) fro details.

    Then configure the database to specify the ReportServer DB for this instance. You could refer to Create a Native Mode Report Server Database for details.

    After finishing configuration, you could re-start the Reporting Service Configuration Manager and check whether it works or not.

    By the way, please do mask sensitive data before uploading your privacy information . 

    Best Regards,
    Zoe Zhi

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Tuesday, October 31, 2017 3:25 AM

All replies

  • Why there is no name in your image while creating a web url?

    This is how the web url looks like right? 

    http://*******:80/ReportServer

    ****** --> represents name of the report server name.

    Please check for log files where you can find on Program files folder for more information about errors.


    Maruthi... http://www.msbimaru.blogspot.com/


    Monday, October 30, 2017 8:56 PM
  • Monday, October 30, 2017 9:01 PM
  • Can you try with TCP Port as "80" and click apply button. Because, TCP Port 80 is a default port for SSRS. Let's see what happens...

    Maruthi... http://www.msbimaru.blogspot.com/

    Monday, October 30, 2017 9:26 PM
  • Hi DataNerdE,

    According to your picture, it seems that when you install the SSRS, you choose only install mode, right? 

    If so, you need to check the following conditions:

    1. You must be a member of the local Administrators group on the report server computer.
    2. If IIS is installed on the same computer, check the names of virtual directories on any Web site that uses port 80. If you see any virtual directories that use the default Reporting Services virtual directory names (that is, "Reports" and "ReportServer"), choose different virtual directory names for the Reporting Services URLs that you configure.
    3. You must use the Reporting Services Configuration tool to configure the URL
    4. Choose a time that has low report activity. 

    You could refer to Configure a URL (SSRS Configuration Manager) fro details.

    Then configure the database to specify the ReportServer DB for this instance. You could refer to Create a Native Mode Report Server Database for details.

    After finishing configuration, you could re-start the Reporting Service Configuration Manager and check whether it works or not.

    By the way, please do mask sensitive data before uploading your privacy information . 

    Best Regards,
    Zoe Zhi

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Tuesday, October 31, 2017 3:25 AM