Share via

User access failure SQL integration

ZM-3283 40 Reputation points
2024-12-11T20:09:16.33+00:00

Hi, im having this issue. How can I grant myself the proper access to pass this stage? I tried everything but it still running into same issue.

A screenshot of the issue I'm having is below. How can I resolve thisScreenshot 2024-12-03 123215.png

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 38,956 Reputation points
    2024-12-12T03:27:27.6166667+00:00

    Hi @ZM-3283,

    Please first try the repair option. Remember to restart sql server service.

    User's image

    Also here is a same thread you may try the solution to see if it is helpful.

    https://techcommunity.microsoft.com/discussions/sql_server/sql-server-2022-ssis-package-deployment-issue-a-required-privilege-is-not-held-b/3911350

    Regards，

    Zoe Hui

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

    0 comments
  2. Olaf Helper 45,371 Reputation points
    2024-12-12T07:33:31.6733333+00:00

    A required privilege is not held by the client

    Start Visual Studio SSDT with "Run as Administrator" on the local server and tyr it again.

    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.