RE: Can't access linked server, except from
- From: Mogens Nielsen - WM-Data A/S <MogensNielsenWMDataAS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 22 Jan 2007 04:47:01 -0800
Hi Jide,
you have to ensure that Named Pipes is turned on as a Client Protocol.
You do this by opening up SQL Server Configuration Manager from the Sql
Server program group.
Underneath the SQL Native Client Configuration you find the Client Protocols
- here the Named Pipes protocol have to be enabled...
That may be the reason - at least its disabled at default.
Regards,
Mogens Nielsen
WM-data Danmark
"jidehem" wrote:
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: jidehem
- Re: Can't access linked server, except from
- References:
- Can't access linked server, except from
- From: jidehem
- Can't access linked server, except from
- Prev by Date: Re: Permissions not applied
- Next by Date: Re: Link with encryption example for 2005
- Previous by thread: Re: Can't access linked server, except from one computer
- Next by thread: Re: Can't access linked server, except from
- Index(es):
Relevant Pages
|
|
