Share via

How to troubleshoot 'Failed to acquire connection "Local server connection"'?

CharlieLor 561 Reputation points
2023-05-02T14:56:42.53+00:00

I have a maintenance plan that I keep getting the following error. Do I need to install SSIS for this to work? In my other server, I do have SSIS installed. I have searched other places for this error but none has resolved this issue for me.

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4312.2 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2023-05-01 14:36:16.64 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

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,010 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,592 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 37,671 Reputation points
    2023-05-03T05:40:08.3733333+00:00

    Hi @CharlieLor ,

    Connection may not be configured correctly or you may not have the right permissions on this connection.

    It seems a permission error.

    First please ensure that the Local server connection has been configured correctly.

    And then please check the account which you are used to run the maintenance plan has the full permission to access the Local server connection.

    It is highly recommended to run the package via proxy account in agent job.

    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
  2. CharlieLor 561 Reputation points
    2023-05-03T15:43:48.6033333+00:00

    If my Local server connection is configured incorrectly, would I be able to see these databases?

    User's image

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.