ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services RSS

• • Reply
  OsorioCA

  None

  0 Points

  5 Posts

  ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 25, 2021 10:10 PM|OsorioCA|LINK

  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?

• • Reply
  mgebhard

  All-Star

  53711 Points

  24035 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 25, 2021 11:23 PM|mgebhard|LINK

  OsorioCA

  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?

• • Reply
  XuDong Peng

  Contributor

  2400 Points

  749 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 26, 2021 07:22 AM|XuDong Peng|LINK

  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

  ASP.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >
• • Reply
  OsorioCA

  None

  0 Points

  5 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 26, 2021 02:05 PM|OsorioCA|LINK

  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)

• • Reply
  OsorioCA

  None

  0 Points

  5 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 26, 2021 02:08 PM|OsorioCA|LINK

  • <div class="comment-right-col comment-body"> <div>

    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)

    </div> </div>
• • Reply
  mgebhard

  All-Star

  53711 Points

  24035 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 26, 2021 02:17 PM|mgebhard|LINK

  OsorioCA

  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???

• • Reply
  OsorioCA

  None

  0 Points

  5 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 26, 2021 02:51 PM|OsorioCA|LINK

  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.

• • Reply
  OsorioCA

  None

  0 Points

  5 Posts

  Re: ERROR WHEN EXECUTING A REPORTING SERVICES 2008R2 Advanced Services

  Mar 26, 2021 02:52 PM|OsorioCA|LINK

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