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:
- SQL - Continue running all SQL statements even after error
- opposite of "top" in sql server, without using order by, there are no keys/indices
- Getting log messages from an SSIS package executed with an SQL query
- Project fails to load due to missing SqlServer.targets file after upgrading to Visual Studio 2013
- How to remove a specific character from a string, only when it is the first or last character in the string.
- convert datetime to bigint
- How to fix the "system cannot find the file specified" error in ASP.NET MVC and SQL Server 2019
- How to get all auto generated foreign key names?
- Untrusted Certificate Error when connecting to SQL Server running in Docker from .NET 7 API in VS2022
- In a junction table, should I use a Primary key and a unique constraint, or a compound/composite key?
- Convert to ASCII char in SQL Server
- SQL transaction locks query weird behavior
- Update SQL with consecutive numbering
- Returning Continuous Months and Copying Values from the Previous Month
- Export stored procedure results as CSV (UTF 8 BOM format) to external server from SQL Server 2012
- SQL Server XML Data - How to insert if empty or update if not
- "Incorrect syntax near ')'." from cmd.ExecuteNonQuery();
- SQL Server - get next Friday in DATETIME
- Prevent Role with limited SELECT access discovering object names in Azure SQL or SQL Server
- What is the best way to create and populate a numbers table?
- How to preserve data comma ',' while exporting data from SQL Server to flat file (CSV) where column delimiter is ','
- SQL Selecting if "active" = true
- Delete partial dulicate rows - sql
- How to disable transactions for individual migrations in Flyway on SQL Server
- Why does a WHERE IN query on a uniqueidentifer column result in a "range seek" (greater than/less than)?
- Stored procedure to insert a new employee and return the newly created record (including the Id)
- Generating a histogram from column values in a database
- Get size of all tables in database
- How can I get the size in bytes of a table returned by a SQL query?
- Reading a table from SQL Server into a DataFrame using SQLAlchemy