Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ddamico
Yak Posting Veteran
76 Posts |
 Posted - 2008-08-07 : 15:55:08
|
| I am trying to create a sql user that will be responsible for running jobs and seem to be having a bit of trouble I am hoping someone has done this and give me a step by step synopsis of how to set this up successfully. Here is what i didFirst I have a two domain accounts one for MSSQL and one for SQLSERVERAGENT.1. Create a windows user on server as part of Users group (test)2. Create a credential called (jobCred) pointing at the window user (test).3 Create a SQL user (jobUser) with credential (jobCred)4. Create a Proxy (jobProxy) for SSIS subsystem with (jobCred) and principal as (jobUser)I then created a Maintenance job and the step executes as proxy (jobProxy). The job itself is set to run as (jobUser).I can't get this to work but if i change the credential to point at the SQLSERVERAGENT account it works. I am hoping someone has done this and could give e a step by step tutorial on how to do this and what permissions i have to set to get it to work.Thanks in advance.Dan D |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 22:30:24
|
| Because job owner has to be sysadmin to run mau=intenance plan jobs. |
 |
|
|
|
|
|
SQL Server Agent (Job User) woes...