Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / May 2005

Tip: Looking for answers? Try searching our database.

MSSQLServerOLAPSevice

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pravin - 20 May 2005 16:07 GMT
all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
working excelp OLAP services, i even restarted the server. In service manager
it shows 'Starting' on status bar.  when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server the server is
either not started or is too busy', Can anyone help me, it's very urgent
Mark Job - 25 May 2005 22:21 GMT
This sounds like it could be related to KB 883656.  I have seen this at a client site, where AS would restart itself every 20-30 seconds, and you will see the state cycle in Service Manager.  

There is a hotfix for this bug, and it is also included in the new SP4.  In order to recover from the corrupted state to allow you to apply the service pack, you'll need to do the following:
           1)       Using the SQL Server Service Manager, select the MSSQLServerOLAPService in the second (Services) drop-down list.  Uncheck the Auto-start service when OS starts box.  

2)       Close the Service Manger.  Reboot the server to get the restart process to stop looping.

3)       Rename the data folder where Analysis Services stores its databases.  By default, this is c:\Program Files\Microsoft Analysis Services\Data but it may be different on your system, particularly if there are alternate drives.  The folder in question will have subfolders along this structure:
 Data
        MyASDatabase
            MyCube1
            MyCube2
            MyCube3
and these lowest level folders will have the many data and aggregate files for each cube inside them.

4)       Create a new folder in the same directory called Data

5)       Restart Analysis Services through the SQL Server Service Manager by selecting the MSSQLServerOLAPService in the second (Services) drop-down list and clicking the Start icon.  Also, check the Auto-start service when OS starts box.  Close the Service Manager.

This should get your instance back to normal, the cubes will rebuild from the stored metadata next time that you use them.  You will need to reprocess.


> all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
> working excelp OLAP services, i even restarted the server. In service manager
> it shows 'Starting' on status bar.  when i try to connect server through MSA
> it gives me error 'cannot open connection to Analysis server the server is
> either not started or is too busy', Can anyone help me, it's very urgent
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.