RE: login failed for user "null"

From: Chris Barnwell (Barnwell_at_discussions.microsoft.com)
Date: 08/27/05 

Date: Fri, 26 Aug 2005 16:53:01 -0700

Are the linked servers set up to "Be made using the login's current security
context"? If that's the case, then I'm guessing that you are having a
problem with delegation. Review the BOL topic "Security Account Delegation"
this will get you going in the right direction. You will need to have a
domain admin assist you with this if you do not have domain admin rights.
After running the setspn command, it may take a while for the change to take
effect. (at least it did in my environment)

"dobrzak" wrote:

> Hello,
> I have problem with linked servers (MS SQL Server 2k)- when I try to execute
> query(update, insert..) with linked servers, I have message Login failed for
> user 'null'. This is very strange problem, some computers in AD (2k3 std)
> don't have this error, when the other have this problem for few hours and
> some have this error all the time. Network Protocols is TCP/IP.
>
> Any idea ?
>
>
>

Relevant Pages

  • Re: Are Domains True Security Boundaries?
    ... The ONLY true bondary of security is the Forest. ... So if you do not trust a group of "domain admin" who for whatever reason you ... > We feel that adding a second domain and giving untrusted domain admin ...
    (microsoft.public.windows.server.active_directory)
  • Read only Admin privileges for Active Directory environment?
    ... Our InfoSec team has requested Domain Admin privileges ... on the corporate Active Directory to audit the environment's security. ...
    (Security-Basics)
  • Re: Admin Acct
    ... > We have an obligation in security documentation to discuss the least ... > SMS without Domain Admin rights. ... >> wants to use advanced security, local admin rights and no domain admin ...
    (microsoft.public.sms.admin)
  • RE: Read only Admin privileges for Active Directory environment?
    ... the Security log as well, ... 'Read only' Admin privileges for Active Directory environment? ... Our InfoSec team has requested Domain Admin privileges ... Our program offers unparalleled Infosec management ...
    (Security-Basics)
  • Re: Setting up an AD structure
    ... Rather than run all the time as a domain admin, you could create regular user accounts for you and your brother. ... Unless you need admin rights frequently, that might work as well, while adding to your security. ... What I have found in our small business is that I generally want all the users and computers to operate under the same policies. ...
    (microsoft.public.windows.server.sbs)