sql server 2008

In our SSAS server, the Analysis services stops by itself (but it shows that service is still started). I always restart service and it works then. it happens once in 1 or 2 months. But as its a prod server,its not acceptable. Any idea why its happening. nothing in window logs
dkumeriAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
lcohanConnect With a Mentor Database AnalystCommented:
Please see article below with similar issues and maybe it helps you find the source as well:

http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/e425ef58-84b2-47f0-8575-51c985e302b6
0
 
lcohanDatabase AnalystCommented:
Did you checked SQL Logs on that box? And SSAS logs? SQL logs are available in SSMS under "Management" section and also directly on the box in a local folder.
0
 
dkumeriAuthor Commented:
no error there as well
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
lcohanDatabase AnalystCommented:
nothing in the msmdsrv.log file? should be under C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log
0
 
dkumeriAuthor Commented:
where I can get msmdsrv.log file? Also " C:\Program Files\Microsoft SQL Server\ " ,I get different option after this path i.e 80, 90, 100 folder
0
 
lcohanDatabase AnalystCommented:
if you are using SQL 2008 it must be under your .\MSAS10...... path.
That's where it is installed by default and other than that you could open SSMS on that box, connect to Analysys Services, right click server name, select Properties, and check "Show Advanced (All) Properties" on the general tab then locate the path to your log file
0
 
dkumeriAuthor Commented:
attached is the msmdsrv.log file but there in nothing informative
msmdsrv.log
0
 
dkumeriAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.