Blog Archives
Weird Problem with SSAS Not Starting
After building a new cluster to replace a 2005 cluster here in the office, I discovered Analysis Services would not start. Usually I do not put Analysis Services on the same box however one of our vendors requires SSRS, SSAS, and the Database Engine to be on the same instance. Frustrating, I know.
When I installed the cluster, everything was operational. However after I applied service pack two to the 2008 R2 Enterprise nodes, Analysis Services would not start. I didn’t notice the first time that it was after the service pack was applied until I removed everything and started over fresh.
The logs were not much help and I could not find much on the internet until I eventually found a friend who suggested that the service running SSAS needed to be in the local administrators group. Problem solved. Now my lesson learned is here for you as well. Enjoy!
SQLSat86 Session Review: Adam Jorgensen’s “0 to SSAS”
The first session of the morning for me was Adam Jorgensen’s “0 to SSAS” presentation. Before this event, I had never had the privilege of attending one of Adam’s sessions and I do not work directly with SSAS, but his reputation as a good speaker enticed me to attend. Needless to say that I was not disappointed. Below are some random things that I learned from Adam:
- AS is the most powerful engine in the SQL Server line (designed to do table scans which would kill the DB engine)
- The Standard Edition for SQL Server is missing some of the AS functionality.
- AS uses BIDS aka Visual Studio with different project types
- AS works best with the STAR schema but might get the job done if your snowflake schema is not too diluted and you do not mind manually adding the dimensions.
- “Add related tables” will only find one level of relations which makes the STAR schema optimized for this.
- It was not said but I am guessing that the constellation schema would kill the engine 😉
SQLSat86 Session Review: Adam Jorgensen’s “0 to SSAS”
The first session of the morning for me was Adam Jorgensen’s “0 to SSAS” presentation. Before this event, I had never had the privilege of attending one of Adam’s sessions and I do not work directly with SSAS, but his reputation as a good speaker enticed me to attend. Needless to say that I was not disappointed. Below are some random things that I learned from Adam:
- AS is the most powerful engine in the SQL Server line (designed to do table scans which would kill the DB engine)
- The Standard Edition for SQL Server is missing some of the AS functionality.
- AS uses BIDS aka Visual Studio with different project types
- AS works best with the STAR schema but might get the job done if your snowflake schema is not too diluted and you do not mind manually adding the dimensions.
- “Add related tables” will only find one level of relations which makes the STAR schema optimized for this.
- It was not said but I am guessing that the constellation schema would kill the engine 😉
SQL Swampland 