I am trying to test a connection in Reporting Services to an Analysis Services 2000 database. I get a Test Connection Succeeded from one machine and I can't even select the databases in the connection properties on another machine. What can I look at that might be preventing one machine from seeing the Analysis Services Server?
Thanks.
Security. If you hardcode the Windows credentials in the connection string does it work? This whitepaper may help.
No comments:
Post a Comment