August 25, 2011 at 4:10 am
Hi,
I have this strange login problem where I'm getting login failed even though the service account that the job runs under has sysadmin permission! The schema was created by user A and when an SP is created it's permissioned as user A even though the job is run by the service account. User A is not permissioned at all, and only trace of user A is on the schema level?
SQL 2008
August 25, 2011 at 4:53 am
TST1 (8/25/2011)
Hi,I have this strange login problem where I'm getting login failed even though the service account that the job runs under has sysadmin permission! The schema was created by user A and when an SP is created it's permissioned as user A even though the job is run by the service account. User A is not permissioned at all, and only trace of user A is on the schema level?
SQL 2008
Can you change the job owner to 'sa' and try it
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply