Post reply

Linked Server - Burp - General Network Error?

  • July 12, 2004 at 12:11 pm

    #162918

    Hi,

    We have had a linked server established for some time (accounts involved).   Today we started getting the following error.   Any idea what is up and how to fix it? 

     

    SQL Server Enterprise Manager

    Error 11:  General network error. Check your network documentation.

     

  • July 12, 2004 at 12:17 pm

    #514294

    Are you able to ping the linked server? You should start the network trace between both servers.

  • July 12, 2004 at 12:24 pm

    #514297

    I can pink the IP address from the command prompt.  Ping statistics and round trip info was fine.  

    How would I run the network trace between both servers?  Is it a program?

  • July 12, 2004 at 12:26 pm

    #514299

    Also, when I tried to do a sp_dropserver @server='NAME' I got the error ... Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44 There are still remote logins for the server 'NAME'.   As a result, I'm a little reluctant to drop/delete the link and try to reistablish.  Should I have to?  Is there a table I can look in to see all logins using this link?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply