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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy