Sunday, March 25, 2012

Analysis service does not remain started

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

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)

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

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)

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

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

sql

No comments:

Post a Comment