Solved

sql server 2008

Posted on 2011-02-15
8
225 Views
Last Modified: 2016-02-14
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
0
Comment
Question by:dkumeri
  • 4
  • 4
8 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 34900358
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
 

Author Comment

by:dkumeri
ID: 34900398
no error there as well
0
 
LVL 39

Expert Comment

by:lcohan
ID: 34900525
nothing in the msmdsrv.log file? should be under C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Log
0
 

Author Comment

by:dkumeri
ID: 34900736
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 39

Expert Comment

by:lcohan
ID: 34900874
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
 

Author Comment

by:dkumeri
ID: 34901059
attached is the msmdsrv.log file but there in nothing informative
msmdsrv.log
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 34901291
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
 

Author Closing Comment

by:dkumeri
ID: 35200361
thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now