We have installed sql server 2008 (64 bit) on windows server 2008 enterprise edition, in which around 10 jobs to populate the dimensions from relational db to analysis cubes.
I am frequently facing the same error and the services gets stopped.
"The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s)."
when i try to restart the analysis services, in next few minutes the service gets disabled.I tried disabling the sql service and disabling the agent jobs which indicates the dawaflow will be stopped.
I have enough memory and cpu resources.
Can any one pour some inputs to solve the issue.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!