{"type":"doc","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Deploying "},{"type":"text","marks":[{"type":"bold"}],"text":"SQL Server Analysis Services (SSAS)"},{"type":"text","text":" to "},{"type":"text","marks":[{"type":"bold"}],"text":"Internet Information Services (IIS)"},{"type":"text","text":" can significantly enhance your data analysis capabilities. This guide will walk you through the process step-by-step, ensuring a smooth deployment experience"}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Prerequisites"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Windows Server with IIS installed"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"SQL Server Analysis Services installed"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Administrative access to both the server and IIS."}]}]}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Step 1: Prepare Your Deployment Files"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Create a new folder for your deployment"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Navigate to "},{"type":"text","marks":[{"type":"code"}],"text":"C:\\\\Program Files\\\\Microsoft SQL Server\\\\MSAS16.SQL2022\\\\OLAP\\\\bin\\\\isapi"},{"type":"text","text":" (adjust the path according to your SQL Server version)"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Copy the following items to your new folder:"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","marks":[{"type":"bold"}],"text":"Resources folder"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","marks":[{"type":"bold"}],"text":"msmdpump.dll"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","marks":[{"type":"bold"}],"text":"msmdpump.ini"}]}]}]}]}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Step 2: Configure IIS"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Open "},{"type":"text","marks":[{"type":"bold"}],"text":"IIS Manager"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Create a new "},{"type":"text","marks":[{"type":"bold"}],"text":"Application Pool"},{"type":"text","text":":"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Set a name for your application pool"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Set the Managed Pipeline Mode to \""},{"type":"text","marks":[{"type":"bold"}],"text":"Classic"},{"type":"text","text":"\""}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Create a new Website:"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Choose the application pool you just created"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Set the "},{"type":"text","marks":[{"type":"bold"}],"text":"Physical Path"},{"type":"text","text":" to the folder you created in Step 1"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Configure \""},{"type":"text","marks":[{"type":"bold"}],"text":"Connect as"},{"type":"text","text":"\" to use a specific user with "},{"type":"text","marks":[{"type":"bold"}],"text":"appropriate permissions"},{"type":"text","text":" (e.g. Read/Write)"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Set a "},{"type":"text","marks":[{"type":"bold"}],"text":"port number"},{"type":"text","text":" (e.g., 8000)"}]}]}]}]}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Step 3: Enable CORS (Cross-Origin Resource Sharing)"}]},{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"You have two options to enable CORS:"}]},{"type":"heading","attrs":{"textAlign":"left","level":3},"content":[{"type":"text","text":"Option 1: Add HTTP Response Headers in IIS"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Select your website in IIS Manager"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Double-click on \""},{"type":"text","marks":[{"type":"bold"}],"text":"HTTP Response Headers"},{"type":"text","text":"\""}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Add the following headers:"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Name: "},{"type":"text","marks":[{"type":"bold"}],"text":"Access-Control-Allow-Origin"},{"type":"text","text":", Value: "},{"type":"text","marks":[{"type":"bold"}],"text":"*"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Name: "},{"type":"text","marks":[{"type":"bold"}],"text":"Access-Control-Allow-Methods"},{"type":"text","text":", Value: "},{"type":"text","marks":[{"type":"bold"}],"text":"GET"},{"type":"text","text":", "},{"type":"text","marks":[{"type":"bold"}],"text":"POST"},{"type":"text","text":", "},{"type":"text","marks":[{"type":"bold"}],"text":"PUT"},{"type":"text","text":", "},{"type":"text","marks":[{"type":"bold"}],"text":"DELETE"},{"type":"text","text":","},{"type":"text","marks":[{"type":"bold"}],"text":" OPTIONS"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Name: "},{"type":"text","marks":[{"type":"bold"}],"text":"Access-Control-Allow-Headers"},{"type":"text","text":", Value: "},{"type":"text","marks":[{"type":"bold"}],"text":"Content-Type,"},{"type":"text","text":" "},{"type":"text","marks":[{"type":"bold"}],"text":"Authorization"}]}]}]}]}]},{"type":"heading","attrs":{"textAlign":"left","level":3},"content":[{"type":"text","text":"Option 2: Add CORS Configuration to web.config"}]},{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Add the following to your web.config file:"}]},{"type":"codeBlock","attrs":{"language":null},"content":[{"type":"text","text":"\n \n \n \n \n \n"}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Step 4: Configure web.config"}]},{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Create or modify the web.config file in your deployment folder with the following content:"}]},{"type":"codeBlock","attrs":{"language":null},"content":[{"type":"text","text":"\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n"}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Step 5: Restart and Test"}]},{"type":"bulletList","attrs":{"tight":true},"content":[{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Restart your "},{"type":"text","marks":[{"type":"bold"}],"text":"IIS website"}]}]},{"type":"listItem","content":[{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Test the deployment by accessing your SSAS through the configured "},{"type":"text","marks":[{"type":"bold"}],"text":"IIS endpoint"},{"type":"text","text":" or test it in "},{"type":"text","marks":[{"type":"bold"}],"text":"Microsoft Excel"}]}]}]},{"type":"heading","attrs":{"textAlign":"left","level":2},"content":[{"type":"text","text":"Conclusion"}]},{"type":"paragraph","attrs":{"textAlign":"left"},"content":[{"type":"text","text":"Congratulations! You've successfully "},{"type":"text","marks":[{"type":"bold"}],"text":"deployed SQL"},{"type":"text","text":" "},{"type":"text","marks":[{"type":"bold"}],"text":"Server Analysis Services to IIS"},{"type":"text","text":". This setup allows you to access your "},{"type":"text","marks":[{"type":"bold"}],"text":"SSAS cubes"},{"type":"text","text":" and "},{"type":"text","marks":[{"type":"bold"}],"text":"models through HTTP"},{"type":"text","text":", enabling "},{"type":"text","marks":[{"type":"bold"}],"text":"easier integration"},{"type":"text","text":" with "},{"type":"text","marks":[{"type":"bold"}],"text":"web applications"},{"type":"text","text":" and "},{"type":"text","marks":[{"type":"bold"}],"text":"providing a more flexible way to consume your analytical data"},{"type":"text","text":"."}]}]}