Share via

SQL Server Analysis server services not starting

Tim Gowen 21 Reputation points
2022-04-11T07:41:41.613+00:00

Consultants have deployed an SQL Server upgrade but they are pushing back on me because two services won't start (Error 5 - Access Denied).
191733-sql1.png

I am not experienced much in SQL and not at all in Analysis Services so I don't know what changes can safely be made to get these services started.
191791-sql3.png191792-sql3.png

Can anyone point me towards admin documentation that covers this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,343 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,416 Reputation points
    2022-04-11T08:23:35.327+00:00

    Never use Windows Service Manager to change anything on SQL Server services.
    Always us SSCM = "SQL Server Configuration Manager", only that tool is aware of required permissions for the services.
    See
    https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver15

    0 comments
  2. Tim Gowen 21 Reputation points
    2022-04-11T08:49:06.717+00:00

    Understood...

    191828-sql4.png

    The service doesn't have the rights - so can I change the service to LocalSystem for a single SQL Server...

    0 comments
  3. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2022-04-11T21:57:28.677+00:00

    If you want to play with the Telemetry service, you will need to do that though the Services applet; it is not exposed in SSCM. Then again, you don't really need that service. This is Microsoft's service that "calls home" to report how you are using SQL Server, or in this case Analysis Services.

    Obviously, if you want to use Analysis Services, you need to fix that one.

    0 comments
  4. ZoeHui-MSFT 41,481 Reputation points
    2022-04-12T02:15:46.9+00:00

    Hi @Tim Gowen ，

    The service doesn't have the rights - so can I change the service to LocalSystem for a single SQL Server

    Yes, you can go ahead and change it to localSystem to see if you can bring it up. If it is still not working ,please share the detailed error messages that you got.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.