Linked servers

From: Anatoli Dontsov (Anatoli@nospam-dontsov.com)
Date: 01/16/03 

From: "Anatoli Dontsov" <Anatoli@nospam-dontsov.com>
Date: Thu, 16 Jan 2003 12:13:59 -0500

Hi, All

I've got 2 SQL servers: ServerA and ServerB.

ServerB is registered in ServerA as a linked server
and the default security is:

For a login not defined in the list above, connections will
...
(o) be made using the login's current security context.

Everything works fine if users use SQL server authentication.
But if users use WindowsNT authentication they can't access
the remote server

select * from ServerB.pubs.dbo.authors

Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Is there a way to allows WindowsNT users to access the remote server? 

--
Best regards, Anatoli
--
Best regards, Anatoli

Relevant Pages

  • Re: Login without password
    ... Sue has provided you with great resources to resolve your issue. ... Protection Program and to order your FREE Security Tool Kit, ... |>How can I delete the login and add it back? ... I migrate the server from ...
    (microsoft.public.sqlserver.security)
  • Re: Unknown Domain user - domain authentication appears limited
    ... (using cached login). ... Microsoft MVP (Windows Server System: Security) ... > due to the following error: Logon failure: the user has not been granted ...
    (microsoft.public.windows.server.security)
  • RE: Penetration test of 1 IP address
    ... I have been asked to perform a security audit of 1 IP address ... You could grab the banner of the HTTP server or run p0f (if you are using ... Another test would be trying to login as ie admin with the company's name ... Audit your website security with Acunetix Web Vulnerability Scanner: ...
    (Pen-Test)
  • Re: Well done HSBC
    ... The security firm know ... the server usually lets you have a couple of time units either way. ... If login fails and then succeeds, ... security code. ...
    (uk.comp.sys.mac)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
Quantcast