November 20, 2008 at 3:33 pm
Greetings,
I've connected to my SQL 2005 database via a SQL authentication account that has sysadmin rights. However, I am unable to modify any jobs that was created by another sysadmin windows account. How can I after connecting to the database via the SQL account impersonate the connection as teh windows account to be able to modify the jobs?
November 20, 2008 at 4:50 pm
If you are sa you should be able to just change the account..what message does it gives.
Can you just make the account be your new one.
November 20, 2008 at 5:09 pm
You could start SSMS using 'runas' with the other Windows Account
Jim
November 20, 2008 at 10:49 pm
I believe that's what I was looking for , thanks!
November 21, 2008 at 11:06 am
I login as myself (Run As, windows authentication), and I can change SQL jobs owned by others (even sysadmins/sa)
November 23, 2008 at 4:44 pm
Or since you're sysadmin you could just use "EXECUTE AS" once you've made your connection to the server. See BOL here for more info.
...though if you're sysadmin it sounds odd that you can't modify a job since sysadmin can do pretty much anything.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply