May 11, 2012 at 8:24 am
If a database is set to Restricted User And theres a maintenance backup plan which is schedule to run everyday, once a day but dosen't. Is it because only members of the db_owner fixed database role and dbcreator and sysadmin fixed server roles are allowed to connect to that database. How can I change the mainenance plan so it can be the db_owner or member of sysadmin?
May 11, 2012 at 8:33 am
check the execution account of the maintenance plan? is it running as the agent account or do you have it running under a proxy. from there you should then be able to get the account running the maintenance plan and assign the nessesary permissions to the login.
May 11, 2012 at 8:43 am
Can I check without kicking of the job & vewing sp_who2.
May 11, 2012 at 8:52 am
yes, it will be the execute as drop down box of the job step
May 11, 2012 at 9:10 am
I view & change the owner_sid in sysjobs to 0x01 which is sa, thanks.
May 14, 2012 at 1:53 am
also if you use a proxy account you will find it in the run as box of the job step, if it says SQL Server Agent Account, then this should already have SA access, if its something else you will need to find the credential the proxy uses then assign the right, rights to the login which is used in the credential.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply