- Problem running reports
- Posted by sqlscott on January 8th, 2008
we get the following error while trying to run reports in crm 3.0
Sql 2005 small biz server
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)
The feature: "Remote access to report data sources and/or the report server
database" is not supported in this edition of Reporting Services.
(rsOperationNotSupported)
Any help on this one???
- Posted by Tyler Peelen [MSFT] on January 8th, 2008
Is your deployment broken out among several machines or are all of the SBS
components on one server? The error sounds like there is a machine hop
between:
1) The report server web server and the database server housing the RS
databases, or
2) The report server web server and the database server housing the CRM
databases
CRM places no restriction on either of those cases, but SQL Workgroup
Edition might (and it appears that it does, given the error you are
receiving). You might want to check out SQL Workgroup Edition documentation
on MSDN for more information about supported deployments for that product.
--Tyler
microsoft.public.sqlserver.reportingsvcs
"sqlscott" wrote:
- Posted by Ken Compter on January 31st, 2008
I am getting the same error, however it is only 1 user. He gets the error on
his laptop using either the web client or Outlook contact. However, if he
signs on using a different machine to the web client, no errors. Any ideas?
"Tyler Peelen [MSFT]" wrote:
- Posted by Imran-mscrmexpert on February 7th, 2008
see
http://support.microsoft.com/kb/946753/en-us
--
Regards,
Imran
MS CRM Certified Professional
http://microsoftcrm3.blogspot.com
Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com
"Ken Compter" wrote:
- Posted by Ken Compter on February 7th, 2008
The client is running CRM 3.0. We solved the issue by adding the users to
the SQLUser Group.
"Imran-mscrmexpert" wrote:
