Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    5

    Question Unanswered: Linked Servers - sql7 to sql2000

    I am trying to run cross server queries from sql7 to sql2000.
    I want to be able to use the NT login to authenticate accoss the link. I have created the linked server with "logins current security context" - however, when I run the sql2000 query from the sql7 server, l get the following message:

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

    it works fine sql2000 to sql2000

    any ideas how I get this to work?

  2. #2
    Join Date
    Apr 2002
    Posts
    16
    What login did you specify in the Security Context?
    If you are trying to use NT authen, make sure the 'NT AUTHORITY\ANONYMOUS' user exists in the db you are connecting to( not only the Master), run from your db to check:

    select master..syslogins.name as login_name,
    sysusers.name as user_name
    from master..syslogins inner join sysusers
    on master..syslogins.sid = sysusers.sid

    Make sure the same user exists and was granted permissions at Win NT.

  3. #3
    Join Date
    Apr 2002
    Location
    VA
    Posts
    18
    You can also try connecting to other sql server using OPENROWSET

    eg from BOL

    SELECT a.*
    FROM OPENROWSET('MSDASQL',
    'DRIVER={SQL Server};SERVER=seattle1;UID=sa;PWD=MyPass',
    pubs.dbo.authors) AS a
    ORDER BY a.au_lname, a.au_fname
    Deepak Khattar

Posting Permissions

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