Re: Can't access linked server, except from



Mogens Nielsen - WM-Data A/S wrote:
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.

Nammed pipes was already my prefered protocol for both servers
and in Client configuration utility. But thank you for your answer.

Another idea ?

Jidé.


.



Relevant Pages

  • Re: ?? Turning Off TCP/IP Client Has No Effect ??
    ... Did you stop and restart the service after disabling TCP/IP ... My setup involves a single machine running "SQL Server Express 2005". ... SSE includes the "SQL Server Native Client". ... when I run SQLCMD (specifying "tcp:" as the protocol) I am still ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 orphaned connections
    ... Once under "SQL Server Configuration Manager Help --> SQL Server 2005 Network ... Client Protocols --> Client Protocols - TCP/IP Properties ". ... It would suggest to me that the "keep alive" setting for the Server Network Configuration relates to how often the server pings the client. ... it describes Keep Alive under TCP/IP protocol as the ...
    (microsoft.public.sqlserver.connect)
  • ?? Turning Off TCP/IP Client Has No Effect ??
    ... My setup involves a single machine running "SQL Server Express 2005". ... SSE includes the "SQL Server Native Client". ... run the "SQL Server Configuration Manager" and under the "SQL Native ...
    (microsoft.public.sqlserver.tools)
  • ?? Turning Off TCP/IP Client Has No Effect ??
    ... My setup involves a single machine running "SQL Server Express 2005". ... SSE includes the "SQL Server Native Client". ... run the "SQL Server Configuration Manager" and under the "SQL Native ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL and DNS
    ... sql server primary runs on tcpip, ... specifies what protocol to use when initiating connection. ... you should use client network utility to configure tcpip ... In a pure DNS ...
    (microsoft.public.sqlserver.server)