none
Cannot install analysis Service

    Question

  • When I try to install the Analysis Service. It prompt error "Service MSSqlSeverOlapService cannot be started. And the analysis service cannot be installed. I have try many times, but the result is same. What is Olap Service and how can I install OLAPService.

    Thanks.


    hon123456
    Wednesday, June 02, 2010 7:00 AM

Answers

  • Hi,

    Each instance of Analysis Services is supported by its own service. The service name for the default instance is MSSQLServerOLAPService. If you specify a named instance of Analysis Services, the service name is MSOLAP$instancename. To install SQL Server Analysis Services, consider the following things:

    1. Windows XP Service Pack 3 is required when you install SQL Server 2008 R2.
    2. On the Server Services Configuration page of the SQL Server Installation Wizard, check the service account for Analysis Services. For more information about choosing the Service Account, please refer to http://technet.microsoft.com/en-us/library/ms174905.aspx
    3.  On the “Analysis Services Configuration” page, you must specify at least one system administrator for the instance of SQL Server. The users or groups that you specify will become members of the server administrator role of the Analysis Services instance you are installing.
    4.  On the “Analysis Services Configuration” page, switch to “Data Directories” tab and make sure the data directories you specified are valid paths.
    If it still fails, please provide us the error messages logged into the setup log files which are located in the %Program files%\Microsoft sql server\100\Setup bootstrap\Log\ folder. For more information about how to View and Read SQL Server Setup Log Files, please see http://msdn.microsoft.com/en-us/library/ms143702.aspx.


    If you have any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Friday, June 04, 2010 5:41 AM

All replies

  • Hello,

    Maybe there are traces from a previous install of SQL Server.

    Please let me know version of SQL Server you are trying to install and the operating system you are running also.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, June 02, 2010 12:41 PM
  • check the below article will help you installation analysis service pre requisites

    http://msdn.microsoft.com/en-us/library/ms143708.aspx

    http://msdn.microsoft.com/en-us/library/ms143708(SQL.90).aspx

    In order to successfully deploy the Analysis Services databases after installation, SQL Server Standard, SQL Server Enterprise, or SQL Server Developer are required. Note that this deployment must be done manually using Business Intelligence Development Studio after installation is complete.

    Wednesday, June 02, 2010 12:51 PM
  • Dear all,

                 I am trying to install Sql Server 2008 R2 Standard edition. And I am trying to install it in Windows XP.

    Thanks.

     


    hon123456
    Thursday, June 03, 2010 12:39 AM
  • Hi,

    Each instance of Analysis Services is supported by its own service. The service name for the default instance is MSSQLServerOLAPService. If you specify a named instance of Analysis Services, the service name is MSOLAP$instancename. To install SQL Server Analysis Services, consider the following things:

    1. Windows XP Service Pack 3 is required when you install SQL Server 2008 R2.
    2. On the Server Services Configuration page of the SQL Server Installation Wizard, check the service account for Analysis Services. For more information about choosing the Service Account, please refer to http://technet.microsoft.com/en-us/library/ms174905.aspx
    3.  On the “Analysis Services Configuration” page, you must specify at least one system administrator for the instance of SQL Server. The users or groups that you specify will become members of the server administrator role of the Analysis Services instance you are installing.
    4.  On the “Analysis Services Configuration” page, switch to “Data Directories” tab and make sure the data directories you specified are valid paths.
    If it still fails, please provide us the error messages logged into the setup log files which are located in the %Program files%\Microsoft sql server\100\Setup bootstrap\Log\ folder. For more information about how to View and Read SQL Server Setup Log Files, please see http://msdn.microsoft.com/en-us/library/ms143702.aspx.


    If you have any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Friday, June 04, 2010 5:41 AM