locked
Analysis service does not remain started RRS feed

  • Question

  • I have installed SQL Server 2005 Standard Edition for our Team Foundation Server install.  I have verified the installation and all seems well, except that the Analysis Services service does not remain started.  I get a message like "Some services stop if there is nothing to do."  The Analysis service needs to be running in order for the TFS install to succeed.  How can I get the Analysis Services service to remain started?

     

    Thanks in Advance

     

    Wednesday, July 12, 2006 5:11 PM

Answers

  • Ah, so after installing SQL, the AS service does not start?  I thought you were looking to autostart during install.  Can you send the exact error message that you get after starting it?  Are there any messages in event viewer?  And are you trying to connect with a domain account or with local system?

    Thanks,
    Sam

    Wednesday, July 12, 2006 9:10 PM

All replies

  • Are you using the autostart parameters during install?  The default is to not start these services.  Here's the snippet from template.ini:

    ;--------------------------------------------------------------------
    ; To use the *AUTOSTART features, specify 1 to start automatically or 0 to start manually. 
    ; NOTE: If you decide to start SQL Agent automatically, then SQL is also started automatically. 
    ; If *AUTOSTART is not specified on the command line, startup is set to manual.

    SQLBROWSERAUTOSTART=0
    SQLAUTOSTART=0
    AGTAUTOSTART=0
    ASAUTOSTART=0
    RSAUTOSTART=0

    Thanks,
    Samuel Lester (MSFT)

    Wednesday, July 12, 2006 6:24 PM
  • I didn't use those parameters - I followed the "How To: Install SQL Server 2005 for Team Foundation Server" doc.  I installed it all interactively.
    Wednesday, July 12, 2006 6:56 PM
  • Since the default is to not start these services, this should be the correct behavior then.  Are you checking the box during install to autostart the services?

    Thanks,
    Sam Lester (MSFT)

    Wednesday, July 12, 2006 7:17 PM
  • Yes.  The problem is that Team Foundation Server will not install if the Analysis Services service is not running, and it is not.  When I start it, it stops immediately.
    Wednesday, July 12, 2006 8:09 PM
  • Ah, so after installing SQL, the AS service does not start?  I thought you were looking to autostart during install.  Can you send the exact error message that you get after starting it?  Are there any messages in event viewer?  And are you trying to connect with a domain account or with local system?

    Thanks,
    Sam

    Wednesday, July 12, 2006 9:10 PM
  • Hi,

    I am getting the same error message.  When I try to start the 'sql server analysis services', then, the error that it cannot be started because it is not in use by other services or programs. What should I do?  I am getting this error message when I try to upgrade from 2005 SQL to 2008 SQL.  And because of this error message, I am unable to upgrade and am stuck at this point without any solutions.  What should i do?

    Monday, May 16, 2011 5:16 AM