Solved

sql server 2008

Posted on 2011-02-15
8
226 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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
 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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