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-18 : 03:19:02
|
| 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. In job I start stored procedure where owner is user "firmi" and I'm doing this"exec firmi.prenos_na_firmi" where prenos_na_firmi is name of stored procedure. Can somebody help me???? |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2001-12-18 : 03:40:26
|
| I've had the same problem before... It had to do with the fact that only members of the sysadmin role can use the SETUSER command. Try experimenting with which user owns the job etc. |
 |
|
|
|
|
|
problem with job execution