Post reply

Configuring HTTP access for Analysis Services: Web server

  • July 19, 2019 at 1:03 pm

    #3664523

    I'm interested in configuring HTTP access for SSAS, and wanted to understand what the standard practice is for deploying the web services.  Do administrators generally create a separate web server just for AS, or is IIS enabled on one of the SQL servers running the instance?  Intuitively, I'd expect it to have its own server but wanted to confirm since I didn't see documentation for infrastructure recommendations.

  • July 19, 2019 at 4:18 pm

    #3664578

    looks like although it has a lot of moving parts to set it up, there's a decent article from Ms to help with the walk through:

    this link is for SQL2017, but it's still the same steps for previous versions.

    https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=sql-server-2017

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 19, 2019 at 5:58 pm

    #3664605

    Thanks, Lowell.

    Reviewed that same documentation.  I didn't see recommendations for where to configure IIS - whether IIS should be its own web server, or is the service is okay to run alongside Analysis Services.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply