none
Linked server error RRS feed

  • Question

  • Hi,

    I am trying to create a linked server of a remote server in my local system.

    I am facing the following error..

    Please guide me to the solution.

    Thanks in advance

    Friday, May 31, 2013 10:08 AM

Answers

  • What SQL Server version you are working on?

    Do you have proper access rights and permission to connect to the Remote server?

    Check, if TCP/IP and Named Pipes are enabled in Remote Server, in Config Manager?

    And, are you executing Linked Server from the same machine, or any remote client?

    The error number is 53, which means Network Path is not Found, try to ping the server, check Server Name in your Linked Server DDL script, Also check for Windows Firewall settings.


    ~manoj | email: http://scr.im/m22g
    http://sqlwithmanoj.wordpress.com
    MCCA 2011 | My FB Page

    Friday, May 31, 2013 11:27 AM

All replies

  • Troubleshooting 101: is the server name you provided correct and does the server allow remote connections?


    The Data Specialist (Blog)

    Friday, May 31, 2013 10:28 AM
  • Yes, It is.. 


    Friday, May 31, 2013 10:37 AM
  • Hi,

    Both of your server are same version?

    Also do u use same username/password in both ?



    Thanks!
    Sundar
    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Friday, May 31, 2013 11:05 AM
  • What SQL Server version you are working on?

    Do you have proper access rights and permission to connect to the Remote server?

    Check, if TCP/IP and Named Pipes are enabled in Remote Server, in Config Manager?

    And, are you executing Linked Server from the same machine, or any remote client?

    The error number is 53, which means Network Path is not Found, try to ping the server, check Server Name in your Linked Server DDL script, Also check for Windows Firewall settings.


    ~manoj | email: http://scr.im/m22g
    http://sqlwithmanoj.wordpress.com
    MCCA 2011 | My FB Page

    Friday, May 31, 2013 11:27 AM
  • Are we suppposed to guess at what steps you took, what versions of sql server (or other vendor's servers) are in use, how you defined the linked server properties, how the machines are logically connected, etc?
    Friday, May 31, 2013 12:47 PM