Share via

Ensure that the server is running Period Analysis Services Processing

Bilal H. Bhatt 116 Reputation points
2025-01-08T06:50:56.34+00:00

Hello,

I have am getting below error while running a job..

I am able to connect the SSAS server with the jobowner,

Source: Period Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End Error DTExec: The package execution returned DTSER_FAILURE (1).

Please help

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,304 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 39,496 Reputation points
    2025-01-09T01:26:26.1866667+00:00

    Hi @Bilal H. Bhatt,

    Make sure that the account the SQL Server Agent runs under has the necessary permissions to execute every single step of your package.

    You may consider using proxy account which has full permission to connect to SSAS server and run the job.

    Here is an official documentation for your reference: create-a-sql-server-agent-proxy

    For more information, see running-a-ssis-package-from-sql-server-agent-using-a-proxy-account.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

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.