What does SQL Server error 229 signify when related to SQL Agent?

Question

Grade: Education Subject: Support
What does SQL Server error 229 signify when related to SQL Agent?
Asked by:
65 Viewed 65 Answers

Answer (65)

Best Answer
(417)
SQL Server error 229, often encountered with SQL Agent, typically indicates a permissions issue. Specifically, it suggests that the account running the SQL Server Agent service or the account specified for a SQL Agent job step does not have the necessary permissions to perform the requested operation. This could be related to accessing databases, executing commands, or interacting with other SQL Server components.