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 |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2001-12-14 : 06:34:56
|
| When I run a job ( distributed query ) it fails with message: Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed. SLQ Server Agents runs on different accounts. What is the problem??? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-14 : 11:50:06
|
| This article from MS might shed some light: [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q231403[/url]I note that they suggest NOT using the SETUSER command because it exists only for backward compatibility. You don't say what your job step is trying to do, but it sounds like you need to find a different way to do it.-------------------It's a SQL thing... |
 |
|
|
|
|
|
problem with job