Execute SSIS package with Proxy - Could not get proxy data for Proxy_id
I am trying to execute an SSIS package using a Credential and Proxy - it works fine with a user with a SysAdmin role and we want to avoid using SysAdmin.
I have followed all the steps to create a Credential and Proxy and set up the permissions for the user in msdb and SSISDb tables and in the Security -> logins
I have followed the steps in the below links as a guide:-
- Run an SSIS Package Under a Different Account
- Running a SSIS Package from SQL Server Agent Using a Proxy Account
- SQL Server Agent - Running SSIS Package with Proxy
Proxy -> properties -> Principals
When I run the job I get the below error - looks like a permission issue
Unable to start execution of step 1 (Reason: Could not get proxy data for proxy_id = 198_. The step failed.
What am I missing?
As you mentioned in the comments, you are using an SQL Server login as a proxy account. While in the Microsoft documentation they mentioned that:
SQL Server Agent proxies use credentials to store information about Windows user accounts. The user-specified in the credential must have "Access this computer from the network" permission (SeNetworkLogonRight) on the computer on which SQL Server is running.
I suggest following one of the following articles to set up an SQL Server agent proxy:
- Insert leading spaces, then the value to a field in varchar(10)
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?
- Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
- No PK or FK when exporting SQL Server database
- SQL Server SELECT LAST N Rows
- SSRS Query execution failed for dataset
- Order by Specific id first then By rest
- Fuzzy phrase similarity in SQL Server
- Union two selects removing duplicates base on some columns (not the full row)
- SQL fill gaps with hold
- Create login and logout rows from single row
- Create Index without name while creating table
- Extracting SQL Server table data to parquet file
- SQL, How to convert VARCHAR to bigint?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- SQL Server query to find all permissions/access for all users in a database
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- inserting data into SQL DB from C# ASP.NET
- Display the average number of days between a customer's last and second to the last transaction
- Fastest way to determine if record exists
- Unrecognized column name that I define
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?