Can't access linked server, except from
- From: "jidehem" <jidehem_antispam@xxxxxxxx>
- Date: Mon, 22 Jan 2007 13:15:34 +0100
Hi, (excuse my poor english).
I want to access data stored on a SQL2000 server using
"SELECT * FROM openquery(SQL2000srv, ..." from a
connection on my SQL2005 server.
I checked "Allow remote connections" on both servers, and
configured Nammed pipes as prefered protocol.
Security is Windows authentification only for both servers.
If I test my query on Management studio on my 2005 server,
everything is OK. But when I test from any other machine,
I have this error : (sorry, I translated it from french :
OLE DB 'SQLNCLI' from linked server returns 'Connection timeout'.
Msg 5, level 16, state 1, Line 0
Nammed pipes : can't open connection to SQL Server [5]. ".).
I can connect to both servers using any connection, so it's not
a user security problem, I think.
Do you have any clues ?
Thank you,
Jidé.
.
- Follow-Ups:
- RE: Can't access linked server, except from
- From: Mogens Nielsen - WM-Data A/S
- Re: Can't access linked server, except from one computer
- From: jidehem
- RE: Can't access linked server, except from
- Prev by Date: Link with encryption example for 2005
- Next by Date: Re: Can't access linked server, except from one computer
- Previous by thread: Link with encryption example for 2005
- Next by thread: Re: Can't access linked server, except from one computer
- Index(es):
Relevant Pages
|
|
