Hi all, please help, my web reporting server can't make connection to as2000
analysis service.

1. Web Server side: (dmz)
- IIS4.0 with rs2005
- there is an as data source (cube) report which work fine internally but
fail in web server -

2. MSSQL2000 in local network (port 1433 and 2725 are open for web server
access)
- db engine is running, it can be accessed by web server
- as engine is running, it fail and don't know/not sure the reason(s) why.

What I can do for this problem :-(.
db engine is using SQL Credentials (id/pwd) - it work fine
while as engine is using Windows credentials - is it the problem? becuase
of two different domains.
can I set SQL Credentials for AS server as well and where is the interface
for setup?

Please advise, many thanks.