June 10, 2008 at 11:27 am
I am running distributed query on one of the server like.
select * from servername.databasename.dbo.tablename.
It works fine for some time and then suddenly gives error message
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Don't understand that sometimes it is working and sometimes not.
June 10, 2008 at 11:38 am
I know what the error means (it's a server transfering authority to another server, that transfers it yet again), but what would cause it to be intermittent, I haven't a clue.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 10, 2008 at 12:05 pm
The wired thing is when I use my desktop to run distributed query gives me an error but when I use remote link server to run the query works fine and then again use query on desktop works fine and after few minutes gives me error on the desktop .
the distributed query always works fine when use remote server but sometime works and sometime not on desktop .
June 16, 2008 at 8:04 am
Just an off-the-cuff guess, is Auto-Close turned on on that database?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 12:44 pm
Are you sure that there are not network connectivity issues between the 2 servers ?
Have you also checked with the Windows Admins to see if they are having any AD replication issues ?
Just a couple of questions off of the top of my head ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 17, 2008 at 1:16 pm
if you are getting 'NT AUTHORITY\ANONYMOUS LOGON'. error from your desktop some time (not always) - it will not be a network issue. If it is a network issue it would have given a differetn error like server doesnot exists/access denied.
what i suspect is it could be a Kerberos authentication issue.
Are to connecting to the SQL server via windows authentication or sql server authentication. If you are using windows authentication, can you try with SQL authentication and see if the error comes again.
Also can you use the remote server IP and port (11.11.11.11,2433) to connect rather the sql server name
subban
June 17, 2008 at 1:18 pm
Also check in the server (where the sql instance is running) event viwer (security) what kind of error your are getting while you try to connect. I am sure you will be getting NTLM errors in the security event log while you get connection error in your desktop
subban
June 17, 2008 at 3:26 pm
Thanks for your comments,
Actually, I created a SQL Login account on remote server and mapped that to local account on the local server under Linked Server Properties and is working fine.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply