RS2005 reports to AS2000 cubes

Hello,

I am using RS 2005 to design reports.

There's no problem when I connect to an Analysis Services 2005 cube.

But when I try to connect to an AS 2000 cube (Foodmart)...

I have read in this forum that I can use "Microsoft SQL Server Analysis Services" provider (or OLE DB)...

Can someone help me please!!

Thank you

What happens when you connect to 2000 cubes? Do you get any error ?

Raj

|||

hello,

I've got SQL 2000 and AS2000 in a machine

And, SQL 2005 and AS2005 in other machine

both are in the same net

I do a new "report server project".

Start generating a new datasource

I select "Microsoft SQL Server Analysis Services" type

And edit the "connection properties"

In the server name, I introduce the IP address

But no database is displayed in the combo

Thanks,

urtzi

RS on Win2003 cannot connect to Analysis Service

I have RS installed on Win 2003 (not domain controller) and SQL server/AS on
a Win 2000 machine. I have no problem openning the report locally through IE
on the RS machine (Win 2003). However, I could not open the same report from
client machines (XP professional, Win 2000). The error message says "An error
has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'DataSourceName'.
(rsErrorOpeningConnection) Get Online Help
Database 'DatabaseName' does not exist. ".
If I pulish the same report to RS on a Win 2000 machines, I don't have any
problem to open the report from any of client machines. I guess it might
related to credentials not being passed correctly. What kind of configurate I
need on a Win 2003 machine.
Thanks.It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
admins.
Regards,
Cem Demircioglu
"BBH" <BBH@.discussions.microsoft.com> wrote in message
news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
>I have RS installed on Win 2003 (not domain controller) and SQL server/AS
>on
> a Win 2000 machine. I have no problem openning the report locally through
> IE
> on the RS machine (Win 2003). However, I could not open the same report
> from
> client machines (XP professional, Win 2000). The error message says "An
> error
> has occurred during report processing. (rsProcessingAborted) Get Online
> Help
> Cannot create a connection to data source 'DataSourceName'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'DatabaseName' does not exist. ".
> If I pulish the same report to RS on a Win 2000 machines, I don't have any
> problem to open the report from any of client machines. I guess it might
> related to credentials not being passed correctly. What kind of
> configurate I
> need on a Win 2003 machine.
> Thanks.
>|||Thanks fro your reply. Are you referring to the service account which starts
the IIS?
"Cem Demircioglu" wrote:
> It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
> admins.
> Regards,
> Cem Demircioglu
>
> "BBH" <BBH@.discussions.microsoft.com> wrote in message
> news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
> >I have RS installed on Win 2003 (not domain controller) and SQL server/AS
> >on
> > a Win 2000 machine. I have no problem openning the report locally through
> > IE
> > on the RS machine (Win 2003). However, I could not open the same report
> > from
> > client machines (XP professional, Win 2000). The error message says "An
> > error
> > has occurred during report processing. (rsProcessingAborted) Get Online
> > Help
> > Cannot create a connection to data source 'DataSourceName'.
> > (rsErrorOpeningConnection) Get Online Help
> > Database 'DatabaseName' does not exist. ".
> >
> > If I pulish the same report to RS on a Win 2000 machines, I don't have any
> > problem to open the report from any of client machines. I guess it might
> > related to credentials not being passed correctly. What kind of
> > configurate I
> > need on a Win 2003 machine.
> >
> > Thanks.
> >
>
>|||I can't remember the account name but it is either IIS (IUSR*) or Report
Server account (NT Authority\Network Service). You can test it by granting
read access to everyone.
Analysis Manager > XYZ Cube > Database Roles > New ... > Membership:
Everyone
Use Windows NT integrated security on the server while creating the data
source.
Hope this helps.
Regards,
Cem Demircioglu
"BBH" <BBH@.discussions.microsoft.com> wrote in message
news:BB12FAB7-F3CE-42D8-8CD4-F3F707A0A0FF@.microsoft.com...
> Thanks fro your reply. Are you referring to the service account which
> starts
> the IIS?
> "Cem Demircioglu" wrote:
>> It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
>> admins.
>> Regards,
>> Cem Demircioglu
>>
>> "BBH" <BBH@.discussions.microsoft.com> wrote in message
>> news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
>> >I have RS installed on Win 2003 (not domain controller) and SQL
>> >server/AS
>> >on
>> > a Win 2000 machine. I have no problem openning the report locally
>> > through
>> > IE
>> > on the RS machine (Win 2003). However, I could not open the same report
>> > from
>> > client machines (XP professional, Win 2000). The error message says "An
>> > error
>> > has occurred during report processing. (rsProcessingAborted) Get Online
>> > Help
>> > Cannot create a connection to data source 'DataSourceName'.
>> > (rsErrorOpeningConnection) Get Online Help
>> > Database 'DatabaseName' does not exist. ".
>> >
>> > If I pulish the same report to RS on a Win 2000 machines, I don't have
>> > any
>> > problem to open the report from any of client machines. I guess it
>> > might
>> > related to credentials not being passed correctly. What kind of
>> > configurate I
>> > need on a Win 2003 machine.
>> >
>> > Thanks.
>> >
>>

RS and OLAP (Database not found)

I tried to use Analysis Services with Reporting Services and all worked fine, when I'm within the VS IDE. But when I upload the rdl to my Reporting Server and execute the report I got an exeption "database ... not found".
I have 1 server with IIS and Reporting Services and 1 server with SQL 2000 and Analysis Services installed.
I there anybody who can help me ?
Many thanks
PeterPeter,
I am having a similar problem. I have RS on one server and AS on a
different server. I have not been able to figure out how to pass the
appropriate credentials from RS to the AS server.
In your solution was RS and As on the same server?
Thanks,
Blaine
"PNeuwi" wrote:
> We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> Peter|||Blaine,
I am having the same problem. Were you able to find a solution?
"Blaine" wrote:
> Peter,
> I am having a similar problem. I have RS on one server and AS on a
> different server. I have not been able to figure out how to pass the
> appropriate credentials from RS to the AS server.
> In your solution was RS and As on the same server?
> Thanks,
> Blaine
> "PNeuwi" wrote:
> > We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> >
> > Peter|||Did you find a solution? I read another article that said something about
setting SSPI=Kerberos on the datasource.
Steve
"George Kousis" wrote:
> Blaine,
> I am having the same problem. Were you able to find a solution?
> "Blaine" wrote:
> > Peter,
> >
> > I am having a similar problem. I have RS on one server and AS on a
> > different server. I have not been able to figure out how to pass the
> > appropriate credentials from RS to the AS server.
> > In your solution was RS and As on the same server?
> >
> > Thanks,
> >
> > Blaine
> >
> > "PNeuwi" wrote:
> >
> > > We solved the problem by adding roles to the OLAP-Database and using this user for the connect. We stored the user information to the report server and used it as windows credentials.
> > >
> > > Peter