http://groups.google.com/group/microsoft.public.crm.deployment/browse_thread/thread/e37b4c7297d14b81
Error :
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘xyz’.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on the
local server machine, or enable remote errors .
solution :
1 = change the datasource to the “Real” database on the reporting
services . Click properties of a single report and then click on data
source and edit the connection string . after that run it . If it
works then reset the IIS and run the report from CRM interface .
2 =You need to publish your reports again (PublishReports.exe) . Find the
following exe on the crm server , it should be at (C:\Program Files
\Microsoft CRM\Reports) or search on drive.
Hi Aamir ,
I already try all your proposed solution. but still I get this error on our CRM 4.0 Reports :
An error has occurred during report processing.
Cannot create a connection to data source ‘CRMQaDS’.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Thanks and Best REgards,
EFren
Hi Efren.
Use this url to access report on server where reports are installed . url (http:///Reports
click on the organizationName_MSCRM
now click on single report and then click on Properities and then Data source from left panel.
Here you have different option
1. shared data source
2.A custom data source
choose A custom data source and connection Type = Microsoft SQL Server
Connection string = plz check your connection string it shuld be like(DataSource=; InitialCatalog= NP_MSCRM.
Choose window integrated security.
2. When you are done then reset the IIS.
3. Please on IIS click on Default website and then right click the Reports and click on Brows.
Hi!
Thanks for your reply.
Your suggestion is working only if you RUN the report on RS server.
But accessing report in other machine gives my same error message.
Best REgards,
efren
Hi erfan,
You should search google for The Connector for Microsoft SQL Server Reporting Services.
Regards
Aamir
What do you mean?
We already have a MS CRM data connector installed in our RS server.
Thanks!
not understanding anything
Kiran,
can you explain plz what do you mean?
I had the same problem but found out it there was no connection string in the data source plus I did change column type.
Actually I need some info about RS Scripter.
I am using RS Scripter.
1. To Creating report deployment script.
2. Deploying the report.
I understood first point. But I stuck in second point. I am following all your steps to deploy the reports. But after doing the modification in the batch file (RS Scripter Load All item cmd). I am executing this batch. This batch file published the report to the report server. But it is not publishing the reports to the report server. I am getting some below error.
1 .Running script “C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\TestReports\SMReports\SMReports.fldr.rss”
Folder /SMReports already exists and cannot be overwritten
2. Running script “C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\TestReports\SMReports\CPU_Monthly.rdl.rss”
The data set `DataSource1′ refers to the shared data source `DataSource1′, which is not published on the report server.
Report DataSources set successfully
Unhandled exception:
Unable to connect to the remote server
With havin so much content do you ever run into any problems
of plagorism or copyright infringement? My site has a lot of completely
unique content I’ve either authored myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any solutions to help stop content from being ripped off? I’d truly appreciate it.
Wonderful site. A lot of helpful information here.
I am sending it to a few pals ans additionally sharing in delicious.
And naturally, thank you in your sweat!
This will likely be helpful for you in future if in but
the you appear with a few monetary requirement once again.
Within twenty four hours financial institution will review your application and revert back you by way of a affirmation
mail in your email inbox or call.
It’s amazing to pay a quick visit this web page and reading the views of all mates regarding this article, while I am also zealous of getting experience.
It’s wonderful that you are getting thoughts from this paragraph as well as from our discussion made here.
I’ve been exploring for a little bit for any high quality articles or blog posts in this sort of space . Exploring in Yahoo I at last stumbled upon this site. Reading this info So i’m glad to
exhibit that I’ve an incredibly excellent uncanny feeling I found out just what I needed. I such a lot undoubtedly will make sure to don?t put out of your mind this web site and give it a glance regularly.
is laser hair removal painful yag laser (1064 nm, q-switched) – permanent hair removal has not been demonstrated – it can
temporarily remove light hairs. A Ruby lasers operate on a shorter wavelength system of only 694 nanometers.
They will be able to give you an estimate on how many sessions you are likely to need and the approximate cost.
Which is why many women seek for more permanent solution or methods of hair removal,
and the most popular is laser hair removal. People who have undergone it report that
it’s similar to gently snapping rubber band against the skin. The FDA has always been stringent on allowing new products to reach the market, and the process for pharmaceutical companies to release new remedies is grueling and cumbersome.
Excellent blog here! Also your site loads up fast!
What web host are you using? Can I get your affiliate link to
your host? I wish my web site loaded up as quickly as yours lol
It’s hard to find knowledgeable people about this topic, however, you seem like you know what you’re talking about!
Thanks