Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    47

    Question Unanswered: Login falied for user(null)

    Hi,
    See if someone could shed some light on the following

    I am getting an error

    Login failed for user(null)
    Reason:Not associated with a trusted SQL Server Connection.

    I am using SQL Server 2000

    I have 2 servers

    ServerA(DatabaseA)
    ServerB(DatabaseB)

    I try to do the following

    ServerA------>DatabaseA----->Storedproc inserting a record in Database B of ServerB

    Please help.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Check that the user is in the AD. I have seen similar errors when jobs were owned by a user removed from the AD - the record of the user is still in the system tables but SQL Server cannot resolve it against the AD. In that circumstance, the return for the user is null.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It's your linked server defined on ServerA for ServerB. How is the authentication made?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •