Hi,

How to configure the Analysis server and Users PC on a different domain
to communicate?


Thanks




*** Sent via Developersdex http://www.developersdex.com ***

Hello John,

FRom Analysis services operation guide:

Because a user must be successfully authenticated before connection to Analysis
Services, there generally must be a common domain structure between the Analysis
Services computer and the client. However, if you do not have a common domain
structure, you have several choices for overcoming this limitation:

.. If you are using Analysis Services 2000 Enterprise Edition, you can configure
Analysis Services for HTTP access through IIS. For more information, see
"Connecting Using HTTP" in SQL Server Books Online or go to the MSDN library
(msdn.microsoft.com) and see the article "Improved Web Connectivity in Microsoft
SQL Server 2000 Analysis Services."

.. You can match the user accounts and passwords between non-trusted domains.
While effective, this option can require significant management overhead
to keep these accounts synchronized over time as passwords change.

.. You can enable the Windows guest account. This is not a recommended approach
because you have no means of auditing who is accessing what data, and access
is not limited necessarily to Analysis Services data. Instead, Microsoft
recommends that you use the SSPI authentication option ANONYMOUS, outlined
earlier in this section.

hope this helps

Hi,

Thanks for the reply.

Is there any alternative connectivity configuration than Web
connectivity using IIS server.

Thanks





*** Sent via Developersdex http://www.developersdex.com ***

Hello John,

see option 2, password matching and option 3, enabling the guest account
in my repsonse.
I don't know of any other options, maybe someone else can confirm this?