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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-06 : 09:29:52
|
| János writes "Firs I'd like to describe the situation to give you an overview of my problem:There are two MS SQL 2000 servers in the domain I need to transfer data between. Let's call them Source and Dest.There's a stored procedure on the Dest server which gets data from certain tables located on the Source server and inserts them into the local tables.The query works fine from ISQL/W but doesn't from the scheduler.The system reports the followings:Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.orRemote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.depending on the user set as job owner and 'Run as'.The job should run every hour so I can'T execute it manually.i need to schedule it.Could you please provide a solution for my problem?" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-08-06 : 10:17:33
|
| The account you used to start the SQLServerAgent Service needs to be configured as a user on the Source server. If you are using the localsystem account you will have to change it to a Domain User account.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Remote server security