Skip to main content
Database Administrators

Return to Question

Post Closed as "Not suitable for this site" by LowlyDBA - John M, Marcello Miorelli, mustaccio, John K. N., John Eisbrener
Bumped by Community user
Bumped by Community user
Bumped by Community user
Incorporated comment; improved formatting; edited tags; edited tags
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

Using Linkedlinked server from win10 pcWindows 10 PC

I have been using sqlSQL Server linked servers for years -, and they have been working fine.. But But now when I try to run a query (on a machine with win10Windows 10) using linked server I get this error:

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

If I then run the same query on my older machine without win10 IWindows 10, I have no problems and never ever had any problems.

And nowNow the funny part begins: ifIf I run the query from my old pcPC (logged on with the same credentials) and then within 5 minutes run the same query from my win10Windows 10 machine - there is no problem...!

It's like if my old machine establishes a connection that is open for about 5 minutes and then times out. And, and my win10Windows 10 machine cannot find out how to establish that connection...

Any ideaideas?

I am just running a query in SSMS logged onto server A querying data from a database on server B, and doing the same thing on both machines.

Using Linked server from win10 pc

I have been using sql linked servers for years - and they have been working fine.. But now when I try to run a query (on a machine with win10) using linked server I get this error:

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

If I then run the same query on my older machine without win10 I have no problems and never ever had any problems.

And now the funny part begins: if I run the query from my old pc (logged on with same credentials) and then within 5 minutes run the same query from my win10 machine - there is no problem...

It's like if my old machine establishes a connection that is open for about 5 minutes and then times out. And my win10 machine cannot find out to establish that connection...

Any idea?

Using linked server from Windows 10 PC

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

If I then run the same query on my older machine without Windows 10, I have no problems and never ever had any problems.

Now the funny part begins: If I run the query from my old PC (logged on with the same credentials) and then within 5 minutes run the same query from my Windows 10 machine - there is no problem!

It's like if my old machine establishes a connection that is open for about 5 minutes and then times out, and my Windows 10 machine cannot find out how to establish that connection.

Any ideas?

I am just running a query in SSMS logged onto server A querying data from a database on server B, and doing the same thing on both machines.

Source Link
Stewen
Stewen
  • 11
  • 1

Using Linked server from win10 pc

I have been using sql linked servers for years - and they have been working fine.. But now when I try to run a query (on a machine with win10) using linked server I get this error:

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

If I then run the same query on my older machine without win10 I have no problems and never ever had any problems.

And now the funny part begins: if I run the query from my old pc (logged on with same credentials) and then within 5 minutes run the same query from my win10 machine - there is no problem...

It's like if my old machine establishes a connection that is open for about 5 minutes and then times out. And my win10 machine cannot find out to establish that connection...

Any idea?