I have a set of reports that I was previously using with my data hosted on SQL Server 2008 R2 Express. I have recently moved my data to SQL Azure and have changed the data sources in my reports to point to my Azure DB. Within Business Intelligence Development Studio (BIDS) I have no problem pulling reports from my Azure DB; however, once I deploy the reports and try running them on my ASP.Net site or directly from mydomain/Reports I get the following error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'RightsManagement'. (rsErrorOpeningConnection) The report server has encountered a configuration error. (rsServerConfigurationError) I have also tried signing up for the Azure Reporting Services CTP2 last week but have not heard anything back. Please help. Thanks. I would also be very appreciative if someone could help get me access to the CTP2 for Azure Reporting.

I have a set of reports that I was previously using with my data hosted on SQL Server 2008 R2 Express. I have recently moved my data to SQL Azure and have changed the data sources in my reports to point to my Azure DB. Within Business Intelligence Development Studio (BIDS) I have no problem pulling reports from my Azure DB; however, once I deploy the reports and try running them on my ASP.Net site or directly from mydomain/Reports I get the following error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'RightsManagement'. (rsErrorOpeningConnection) The report server has encountered a configuration error. (rsServerConfigurationError) With regards to the error above, could you verify that the account under which the SQL Server Reporting Services service is running has network access. Typically, if the service is set to run as "Local Service" then it will not be able to fetch data from SQL Azure - which could cause the error you're seeing.

I have a set of reports that I was previously using with my data hosted on SQL Server 2008 R2 Express. I have recently moved my data to SQL Azure and have changed the data sources in my reports to point to my Azure DB. Within Business Intelligence Development Studio (BIDS) I have no problem pulling reports from my Azure DB; however, once I deploy the reports and try running them on my ASP.Net site or directly from mydomain/Reports I get the following error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'RightsManagement'. (rsErrorOpeningConnection) The report server has encountered a configuration error. (rsServerConfigurationError) With regards to the error above, could you verify that the account under which the SQL Server Reporting Services service is running has network access. Typically, if the service is set to run as "Local System" then it will not be able to fetch data from SQL Azure - which could cause the error you're seeing. I just checked. The Service Account is indeed set as "Local Service", while the execution account is not set. Should the Service Account be changed to "Network Service" in the Reporting Services Configuration Manager? Do I also need to add/change the Execution Account? Thanks for your help so far.

In my network environment the following works: Set the Service Account to a valid user or service account (domain\user) - one that has access to the Internet from the RS machine. Ensure that the RS machine and user account combination can access the Internet in your network configuration. Ensure that the Execution Account is not set. Hope this helps, Rein

In my network environment the following works: Set the Service Account to a valid user or service account (domain\user) - one that has access to the Internet from the RS machine. Ensure that the RS machine and user account combination can access the Internet in your network configuration. Ensure that the Execution Account is not set. Hope this helps, Rein This still isn't working for me. I've even tried using an administrator account on the machine. Still getting the same error posted in the first post. How can I verify the account combination's internet access? This machine is in a dedicated hosted environment. When I use remote desktop to administer the machine, the user account used has no trouble accessing the internet via IE. Any other ideas of what I can check or try doing other then praying the CTP invites go out in the next few days ;)?

In my network environment the following works: Set the Service Account to a valid user or service account (domain\user) - one that has access to the Internet from the RS machine. Ensure that the RS machine and user account combination can access the Internet in your network configuration. Ensure that the Execution Account is not set. Hope this helps, Rein This still isn't working for me. I've even tried using an administrator account on the machine. Still getting the same error posted in the first post. How can I verify the account combination's internet access? This machine is in a dedicated hosted environment. When I use remote desktop to administer the machine, the user account used has no trouble accessing the internet via IE. Any other ideas of what I can check or try doing other then praying the CTP invites go out in the next few days ;)?

Hi Vincent, Can you please verify whether you have added your Server' IP Address in SQL Azure Firewall ? For step by step instructions for configuring SQL Azure Firewall, read this article http://sqlxpertise.com/2011/05/21/how-to-access-sql-azure-from-anywhere-or-how-to-disable-sql-azure-firewall/Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com If you found this post useful, let us know by clicking "Vote as Helpful" and Propose as Answer