System Center Service Manager Data Warehouse Analysis Services installation error

If you’re installing System Center Service Manager’s Data Warehouse and hit an error on the “Configure Analysis Services for OLAP cubes” wizard page stating the server is not available, this is almost always a connectivity or naming issue between the Data Warehouse setup and your SQL Server Analysis Services (SSAS) instance, rather than SSAS being genuinely broken.

Things to Check

• ServerInstance name format — make sure you’re entering it exactly as SERVERNAMEINSTANCENAME (or just SERVERNAME if it’s the default instance), matching exactly what’s registered, not an alias or IP address that might not match the SPN.
• SSAS service is actually running — check the SQL Server Analysis Services service status on the target server.
• Firewall/ports — SSAS typically listens on TCP 2383 for a named instance’s default connection (or dynamically for others, resolved via the SQL Browser service on UDP 1434) — confirm both are reachable from the Service Manager management server.
• Permissions — the account running Data Warehouse setup needs to be a member of the Analysis Services server role (Administrators) on the target SSAS instance, not just local admin on the box.

Because this error can stem from any of several different underlying causes depending on your specific network and security setup, work through these systematically rather than assuming any single one is definitely the culprit — checking SSAS connectivity independently (for example, connecting to it directly via SQL Server Management Studio from the Service Manager server) is a good first diagnostic step before touching Data Warehouse setup again.

Resources

• SQL
• guide