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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2008-12-08 : 13:59:57
|
| I will be doing cross server queries most of the time and i want to set up linked server with windows authentication every where. for exampleI login into a remote computer (server A) through Remote desktop and pull data into server B from Server C . everytime i get ANONYMOUS LOGON error as my terminal is different and querying from 2 other servers. If i create a sql login between those servers then it works which i dont want to do as we are restricted to use only windows authentication but not sql logins. How could i achieve this through windows authentication.thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 08:27:45
|
| Then read about Security account Delegation and Kerbosis Authentication in books online. |
 |
|
|
|
|
|
Login failed for user 'NT AUTHORITY\ANONYMOUS