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 |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2004-07-09 : 08:27:42
|
Hi, I'm seeing some strange behaviour through a linked server here.Server A has a link to Server B.I can log on to both Servers no problem from QA.If I am logged on (to Windows) on Server A and I open a QA window, then I can execute a linked server query to Server B with no problem.If I am loggon on to my client machine, then open a QA window onto Server A, then when I try the exact same linked server query I get -Server: Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I am at a loss to see why I would get this message. The logon failed is from the remote, linked server, Server B. But it does not appear if I physically sit on Server A and do the same exact thing, only when I'm trying through the client.The link is fine, I've already tried removing it and setting it up again. Any ideas?-------Moo. :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-09 : 13:08:13
|
| We get this same thing too when we use NT authentication. SQL authentication works every time. When SQL authentication is not an option, we modify the linked server to use a specific account. I've subscribed to this thread in case anyone has a resolution for you as I am interested in it as well.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-09 : 23:14:22
|
| I can't get this to work either. Drives me insane. It does work with Windows 2003 though. You have to make sure that DTC is running with the Network Service user. MS actually has a resolution to the issue. You have to set up an SPN (I believe this is right) for each instance of SQL Server. I'm currently researching this and trying to get it working in our environment. I'll update you guys if we find something that actually works.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-07-12 : 06:07:54
|
| There's an old MS bulletin that describes this in relation to SQL 7 but does not say if it still occurs in 2000. There's also stuff in the BOL for sp3 that mentions it. There's no way I can set all the kerberos / delegation things up though to test out the solutions.BOL - Security Account Delegation details the resolution (I think) ??http://support.microsoft.com/default.aspx?scid=kb;en-us;238477-------Moo. :) |
|
|
|
|
|
|
|
|
Odd Behaviour of Linked Server