Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

is there a convenient way to expose SSAS to users in following scenario?

User's are located in Local Area Network, thru it users can access in frontend part of separated network and thru it they can access to backend part of separated network in which lies SSAS service.

User's should be able to connecto to SSAS with MS Excel.

share|improve this question
I'm confused, as long as the network topology doesn't block traffic on the right ports (default: 2383) then you should be able to create a direct connection from excel to SSAS. Whats preventing you from this this? – Bart Sep 2 '11 at 19:41

Normally there's an application server in the way, such as a web technology/Sharepoint/etc - so the end users connect to that app server, and the app server consumes the data from Analysis Services or SQL Server relational data.

share|improve this answer
I see. Unfortunately SharePoint Enterprise (with Excel services) is too expensive for my budget. My application would be just Excel connected to SSAS :-( – windows newbie Jul 20 '11 at 22:20
Perhaps this can be used as a solution? – windows newbie Jul 20 '11 at 22:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.