Reporting Services and Analysis Services

I have Reporting Services on one server and SQL and Analysis Services on another Server. I can develop a report using Analysis Services as the source from my local machine and it works fine. When I deploy it to the Reporting Services Server, it gives the following error:

An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused it

Thank you in advnace for any help.

James

Also, I am running Reporting Services 2005. The Reporting Services databases are on a SQL2005 box and the Analysis Services is 2000 and it is on a seperate box.|||

Check the credentials that are specified. When you are working with a report in Report Designer you have specified in your project what credentials to use. When you publish, those may or may not be the same credentials that are used on the server. Go to Report Manager, navigate to the data source and see if what is specified is what you expect.

|||

I have used 'Credentials stored securely in the report server' and verified my credentials. I use the same credentials for the AS2005 server, which I can report against, also.

Has anyone had luck with this configuration of using RS2005 on its own box and reporting off of AS2000?

|||

If you haven't done so, you need to check also the Use as Windows credentials when connecting to the data source checkbox. You user name has to be in the format domain\user. If this doesn't work, Active Directory may be messing things up. One thing you can check is to create a local Windows account on the AS2000 box and use its credentials to rule out AD.

sql