question

joesnyder1 avatar image
joesnyder1 asked

INSERT permission was denied on the object 'SchemaChangeLog'

This is driving me crazy...I keep getting this error when running a job using Agent: INSERT permission was denied on the object 'SchemaChangeLog' It runs fine when in BIDS debug mode. I've tried setting permissions on the database and on the table itself for the Agent user (and all the users). I feel like I'm missing something simple, what is it? -- edit SQL Server is 2012. SSIS is VS 2010 on the server interestingly enough, if i deploy the same package using VS 2008 from my workstation, and create the job there, it runs fine
insertbidsdenied
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

No chance the job is running with a proxy account rather than the agent account?
0 Likes 0 ·
None. No proxies created at all.
0 Likes 0 ·
If any answers are helpful, indicate this by clicking on the thumbs up next to them. If any answer solved your problem, indicate that by clicking on the check box next to it.
0 Likes 0 ·
KenJ avatar image
KenJ answered
It sounds like it almost has to come down to the agent account not having rights, or the package pointing to a different instance or database when run from the job (different config file?)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

eric_russell avatar image
eric_russell answered
Run a SQL Server Profiler trace and filter on the object SchemaChangeLog. That will at least tell you for sure what account is being used.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.