 | |
Re: OLAP and Reporting Services Weirdness
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: OLAP and Reporting Services Weirdness -
02-22-2005
, 11:38 AM
|
Jim, It is due to security credentials that report server uses in order to access Analysis Services. While developing in VS, RS uses your credentials with full trust. Create a role in Analysis Services and add that role to IUSR in the domain. That should solve the problem, or you can grant access to everyone and narrow it down to necessary users. Regards, Cem Demircioglu "Jim" <emailjeffp (AT) yahoo (DOT) com> wrote in message news:1106155327.252758.197850 (AT) f14g2000cwb (DOT) googlegroups.com... Note: Also posted in microsoft.public.sqlserver.reportingsvcs ------------ I have a stand alone win2k3 reporting services server(i.e. SQL is not on the box). RS SP1 is installed. I have a SQLRS report developed in visual studio (on the same box) that runs MDX against an analysis services cube. I am using the OLE DB provider for OLAP services 8.0. (Note that we had to run ptsfull.exe on the reporting services server to get the pivot table service and 8.0 provider to be available) I can successfully connect to Analysis Services and preview the report in visual studio. When I run the report in Report Manger, the report bombs with... An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'AAHP'. (rsErrorOpeningConnection) Get Online Help Database '<source name>' does not exist. I have a AS database role setup that should allow the stored credentials to successfully authenticate. Any thoughts? Thanks! |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.