1) make sure both servers have the Analysis Services SP3 installed on them
(there are two separate download for SP3 -- one for the RDBMS and one for
AS)
2) make sure that both machines are in a common (or trusted) domain
3) make sure that the remote domain username is included in the OLAP
Administrators local group on your Analysis server.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"olaplamer" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hello,
how can I connect to OLAP server using Analysis Manager
from remote workstation? How to configure it? When I
register server in Analysis Manager and then try to
connect I receive an error message: cannot open connection
to analysis server ''. Error in data [Possible data
corruption].
Regards |