1

We use SQL Server 2005 and sometimes our Analysis Services won't start. A simple reboot solves the problem, however, I'm trying to find a solution that does not rely on that.

If I try to start it from the "SQL Server Configuration Manager", I get a timeout error. When starting from windows' services manager, it states that the service was "started and then interrupted".

The windows application log has three entries:

1 - The flight recorder was started.
2 - The service cannot be started: The following system error occurred: . The following system error occurred: .
3 - Service stopped.

I have also tried to start "Analysis Services" with every single logon option. The same error occurs.

Improve this question
1
  • 2
    As a side note: SQL Server 2005 has been totally out of support since 2016. Upgrading to modern version is strongly encouraged.
    – vonPryz
    Jan 24, 2019 at 12:37

1 Answer 1

Reset to default
0

Are you doing a service restart or a Stop and start in SQL Server Config Manager? I had a similar issue on an old 2005 box and if I did a restart of SQL services in SQL server config manager the issue would not be resolved until I do a Stop and start or reboot the server.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.