June 7, 2011 at 12:14 pm
Ok, wierd case, I am getting the error when trying to start a maint plan job:
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account
However, the owner of the job is the sa account (renamed to another name), AND the person trying to start the job is a sysadmin by way of a group for all DBAs. Also the person who created the plan is a sysadmin.
I checked:
SELECT IS_SRVROLEMEMBER( 'sysadmin', 'new_sa_name' )
And it returned 1 indicating it was a sysadmin.
SELECT IS_SRVROLEMEMBER( 'sysadmin', 'domain\groupname' )
And it returned 1 indicating it was a sysadmin.
SQL Agent and SQL Server use same login account.
the renamed sa account is not disabled and I can login as that user with no problem.
The only thing I can point at is the sa being renamed.
Am I totally missing something?
Oh, one more wrinkle it is SQL 2008R2.
CEWII
June 7, 2011 at 4:13 pm
Think I will try re-renaming sa..
CEWII
June 7, 2011 at 4:28 pm
I know you probably tried this but to confirm. Have you tried to create the proxy account to appease the system?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 8, 2011 at 8:47 am
No, and I didn't want to, because this should work. I may try that after I un-rename the sa account.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply