locked
ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1469560465 posted
    I have SQL server 2008R2 version Advanced Services and reporting services installed on my computer. To do this, design a report which connects to a remote server that contains the database with the information. When I run the report from the report designer, the connection appears successful and is generated correctly, but after publishing it and entering the site and clicking on the report it generates this error. Could someone tell me what the problem is?
    Thursday, March 25, 2021 10:10 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    User475983607 posted

    I have SQL server 2008R2 version Advanced Services and reporting services installed on my computer. To do this, design a report which connects to a remote server that contains the database with the information. When I run the report from the report designer, the connection appears successful and is generated correctly, but after publishing it and entering the site and clicking on the report it generates this error. Could someone tell me what the problem is?

    What is the error?

    Thursday, March 25, 2021 11:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-939850651 posted

    Hi OsorioCA,

    I'm not sure if you have any problems when publishing it, I think you can refer to this document.

    https://docs.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-ver15

    And based on your description alone, we cannot determine your problem. Could not establish connection or some other error?

    If possible, please provide detailed error information so that we will be able to better discover the cause of the problem and try to search for a solution.

    Best regards,

    Xudong Peng

    Friday, March 26, 2021 7:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1469560465 posted
    Error processing the report. (rsProcessingAborted)
Cannot create connection to data source 'DataSource1'. (rsErrorOpeningConnection)
This edition of Reporting Services does not support the feature "The edition of Reporting Services that you are using requires that you use SQL Server relational databases for report data sources and the report server database." (rsOperationNotSupported)
    Friday, March 26, 2021 2:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1469560465 posted
    • Error processing the report. (rsProcessingAborted)
Cannot create connection to data source 'DataSource1'. (rsErrorOpeningConnection)
This edition of Reporting Services does not support the feature "The edition of Reporting Services that you are using requires that you use SQL Server relational databases for report data sources and the report server database." (rsOperationNotSupported)
    Friday, March 26, 2021 2:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User475983607 posted

    Error processing the report. (rsProcessingAborted)
    Cannot create connection to data source 'DataSource1'. (rsErrorOpeningConnection)
    This edition of Reporting Services does not support the feature "The edition of Reporting Services that you are using requires that you use SQL Server relational databases for report data sources and the report server database." (rsOperationNotSupported)

    Have you looked up the error message?

    https://stackoverflow.com/questions/16442056/ssrs-remote-server-access

    I'm guessing you are using SQL Express???

    Friday, March 26, 2021 2:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1469560465 posted
    The database is located on a remote server 2008 R2 which has the version of sql (Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)) and on another computer which has the site configured, where I designed the report and published it, has the version (Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.2 <X64> (Build 9200:) ), according to the article in question, the version of SQL with advanced services does not support remote connections, nor does it support subscriptions, could you confirm if this is where the error comes from? . Thank you very much in advance for all the support with this topic.
    Friday, March 26, 2021 2:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1469560465 posted

    https://docs.microsoft.com/es-es/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-ver15  

    Friday, March 26, 2021 2:52 PM