| Author |
Topic |
|
cr8nk
Yak Posting Veteran
77 Posts |
 Posted - 2008-07-22 : 12:25:18
|
| I need to assign a sysadmin owner to my backup/defrag jobs.The SA account is disabled in our configuration and the SQL Agent account is a windows account but doesn't have a SQL Login because it is part of the SQLServer2005SQLAgentUser group. I am not able to assign a sysadmin to the job because I can't choose a group as a job owner.What is the recommended practice to assign logins to jobs? Should it always be SA? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-22 : 16:05:14
|
| Did you have domain account while installing SQL Server? Your jobs should run on domain account. Does your SQL agent run on local system account? |
 |
|
|
cr8nk
Yak Posting Veteran
77 Posts |
Posted - 2008-07-22 : 18:01:00
|
| Yes, the sql agent account and sql service account are both windows accounts. However they don't have a seperate sql login. They are part of the SQLServer2005SQLAgentUser and SQLServer2005SQLServerUser groups respectively. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-22 : 23:07:17
|
| You can add them as sql login. |
|
|
|
cr8nk
Yak Posting Veteran
77 Posts |
Posted - 2008-07-23 : 12:13:23
|
| I know adding them is an option, but is it the right thing to do? The reason I ask is that the SQL Agent account is already part of a login group. Does it violate any best practices to add them as a seperate login as well? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cr8nk
Yak Posting Veteran
77 Posts |
Posted - 2008-07-24 : 00:47:29
|
| The SQL Server Agent group is added, but I can't assign it as owner to the jobs. Do people usually add the windows account that the agent running is under as a login in addition to being part of the SQL Agent Group? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-24 : 13:47:06
|
| >> Do people usually add the windows account that the agent running is under as a login in addition to being part of the SQL Agent Group?Have to say that old word again, depends. Add it when need it. |
|
|
|
cr8nk
Yak Posting Veteran
77 Posts |
Posted - 2008-07-24 : 14:57:53
|
| I guess I'll have to add it, but I feel funny about it, it doesn't feel clean. Thanks for the advice! |
|
|
|
|
Which login should own my jobs?