remote access to sql server2000 sp3

From: maria (mariaisabelguzman@icasa.com.gt)
Date: 02/17/03 

From: "maria" <mariaisabelguzman@icasa.com.gt>
Date: Mon, 17 Feb 2003 09:52:48 -0800

Hi, i installed sp3 on two servers running sql server
2000. I need to configure this servers as remote and
enable the data access option on them and when in server 1
i execute a select statement to server2 i get this error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

After that, i try it with linked servers and if i check
the option "Be made without using a security context" i
get this error:

OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Invalid authorization
specification]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IDBInitialize::Initialize returned 0x80004005:

and if i check the option "Be made using the login's
current security context", i get this error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

could you tell what am i doing wrong??

Or could you tell me how to cofigure servers as remote or
linked and enable the data access option??

Thanks a lot

Relevant Pages

  • Re: configuration of 2 remote sites
    ... The users at the remote siites will need to access ... You should configure the sites and assign the proper subnets ... to these sites and then use IFM to promote the new additional servers, ... you're using different subnets you may want to setup WINS at these remote ...
    (microsoft.public.windows.server.active_directory)
  • Re: What happens to my W2K domain controllers
    ... Make sure you make the remote dc's gc's as well ... >> offices (running AD-integrated DNS) ... > 2003 member servers. ... >> 8) Run dcpromo on all four old W2k DCs to demote them to member servers. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Restricting access to a web server by IP
    ... > remote control clients, etc - we remotely ... > The agrument against is that mpst vulnerabilities seem to come through ... > servers, and blocking access to all IPs accept those on the allowed list - ...
    (comp.security.misc)
  • Re: Restricting access to a web server by IP
    ... > remote control clients, etc - we remotely ... > The agrument against is that mpst vulnerabilities seem to come through ... > servers, and blocking access to all IPs accept those on the allowed list - ...
    (comp.security.firewalls)
  • Re: Restricting access to a web server by IP
    ... > remote control clients, etc - we remotely ... > The agrument against is that mpst vulnerabilities seem to come through ... > servers, and blocking access to all IPs accept those on the allowed list - ...
    (alt.computer.security)