We have an application that connects to two 2005 servers. We have set up
linked servers and they seem to be working correctly.

The application runs correctly on all PC's but one. It doesn't matter who
logs in to this PC, they all get the same error:

Begin trace:
at QCFeedback.clsQCF.Run() in
C:\vsprojects\QCFeedback\QCFeedback\clsQCF.vb:line 56
at QCFeedback.Main.Main(String[] astrArgs) in
C:\vsprojects\QCFeedback\QCFeedback\Main.vb:line 0

QCFeedback-->clsQCF::Run:
-->Unexpected error occurred in clsQCF:Run
..Net SqlClient Data Provider-->SqlConnection::OnError:
-->Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

END TRACE


If the same user logs in on another PC, the application works correctly.

thanks in advance.

--
jimbo345

jimbo345 (jimbo345 (AT) discussions (DOT) microsoft.com) writes:
You say that the application connects to two SQL 2005 servers. But then
you start to talk about linked servers.

Does the application connect directly to both servers? Or does it
connect directly to server A, and then server A connects to server B
through a linked server definition? It seems from the error message
that the latter is the case, but it could certainly help if you could
describe your set up more clearly.

How was the linked server set up? It does not seem that you have
set up a remote server login, but you are just hoping that the
connecting user will be connected on the other machine too.

This is not my area, but I know there are issues with double hops in
delegation. Probably this workstation is in a different domain than
the rest, or there is something else that is differernt Windows-wise.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sorry, should have been clearer.

We have set up linked servers that work correctly. This user works from any
other PC. Any user that logs onto this PC has the same problem. It is in
the same domain, same setup as all the other PC's, it just won't connect.

The linked servers were set up using delegation and this works for all users
on all PC's.

Might just rebuild this one and see if that solves it.
--
jimbo345


"Erland Sommarskog" wrote:

jimbo345 (jimbo345 (AT) discussions (DOT) microsoft.com) writes:
Probably.

It appears that there is some Windows/AD mumbo-jumbo which is not the
way it should be. I'm sorry that I cannot help; I would have been as
clue as you, if not cluelesser.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I have rebuilt the PC and everything is working correctly. There wasonly
this PC that was having the problems, so was not and AD problem.
--
jimbo345


"Erland Sommarskog" wrote: