SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

The job step requires a proxy account, however proxy matching is disabled on the target server

published 585 days, 11 hours, 1 minute ago posted by

sa 594 days, 12 hours, 55 minutes ago

The job step requires a proxy account, however proxy matching is disabled on the target server

From the error text it is clear that Proxy settings are not matching between the servers, in a multi-server environment it is essential to configure the proxy server settings correctly to ensure no errors reported while executing the jobs. From SQL Server 2005 onwards the security around SQLAgent service has been changed in terms of configure a user to create or execute the schedule jobs, you must first add an existing SQL Server login or msdb role to any of the SQL Server Agent fixed database roles:...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: DBA, Distributed Transactions, multiple, proxy, Security, setup, SQL Server, SQL Server Agent, ssis package, target server

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

The job step requires a proxy account, however proxy matching is disabled on the target server

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up