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 - 2002-03-07 : 02:55:01
|
| when I start job on one server witch is connecting to another I receive this message Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This happened when one server is win NT and the other is win2k.microsoft say:To work around this problem, map the clients on server A to a standard security login on server B, by using either the sp_addlinkedsrvlogin stored procedure or the Security tab of the Linked Server Properties dialog box in Enterprise Manager. But this only works when all the logins in the server I map with only one login on remote machine.I think that SQL Agent account start the job with his Nt starting account.What if remote user that I map all logins to is administrator of the remote server??All the users that connect to local server only with read permmisions will have administrators rights to remote machine.Somebody solve this problem?? |
|
|
|
|
|
Linked server problems