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 |
|
ramaiah
Starting Member
27 Posts |
 Posted - 2011-02-09 : 15:57:53
|
| Hi Team,We have server A,B and C. We have configured Linked server B on A. We have a service account 'domain\name' having permissions on A, B and C. We are trying to access the linked server from C, getting double hop authentication issue 'NT AUTHORITY\ANONYMOUS LOGIN'. How we can resolve this issue. Please suggest us.Thank you,-Ram |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2011-02-09 : 17:14:49
|
| Is there any work around for using windows authentication? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2011-02-09 : 17:45:55
|
| Hi Tara,I have not find any resolution in the mentioned article. Can you please help me?Thank you,-Ram. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2011-02-09 : 17:55:14
|
| ok..Thanks for your help Tara |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-09 : 22:30:09
|
| You need to set the SPNs, and allow delegation for the sql service accounts in AD.And of course, the service account needs to be a domain account. |
|
|
|
|
|
|
linked server double hop authentication