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 |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2006-06-03 : 01:36:29
|
| Hi,I'm getting the following error message everytime tried to run the job in server agent.We are using Windows Auth to login the server and I'm the domain admin in the AD organization unit. I have no idea why not let me running the server agent job. It seems related to some trusted connection for the domain amd the SQL server. The SQL server is installed on the PC that running Windows 2000 Professional (NOT WINDOWS SERVER). Any one have any idea? or how to get around? please help! I need to set schedule to run the job in server agent quick. Thanks a lot != ERROR MESSAGE =<The job failed. Unable to determine if the owner (DOMAIN\USER) of <job Get It has server access (reason: Could not obtain information <about Windows NT group/user 'DOMAIN\USER', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)). |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-03 : 11:32:56
|
| If you have an sa login then you can set the job to be owned by sa. Doesn't affect how it runs.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Can't run jobs in Server Agent?