Post reply

SQL server remotely not connectable

  • September 14, 2011 at 10:15 am

    #244879

    Hi,

    I trying to connect the sql server 2000 workgroup editon on a remote server to a sql server 2005 enterprise edition and it doesn't connect.

    I wrote the i p address in ssms 2005 server name..

    It showing this error:---

    (attached)

    I checked that the remote connections on that server are ON and

    named pipes,TCP are also enabled.

    I try to ping the server from my server and it is pinging successfully..

    P.S.-- before few days/weeks... i could connect to it ( so those servers are in same domain/network...nothing changed from that time )

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • September 14, 2011 at 12:54 pm

    #1381563

    any views??

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • September 14, 2011 at 6:57 pm

    #1381697

    Did you setup a Linked Server between the 2 servers successfully ?

    This error generally means SQL Server instance is not available and is stopped .

    Please post more details and in a clear manner.

    Thank You,

    Best Regards,

    SQLBuddy

  • September 15, 2011 at 6:47 am

    #1381892

    Hi,

    Yes I have already created a linked server to it.

    But when I test connection, I get this error:--

    (Attached)

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • September 15, 2011 at 12:57 pm

    #1382225

    Have you checked the firewall on the linked server? If it is enabled, turn it off to test, if that works, you will need to add the port 1433 or just leave it off.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • September 15, 2011 at 5:46 pm

    #1382324

    How are you testing the connection ?

    In the SSMS, are you able to expand the nodes in the LServer and view the tables and other objects ?

    Also did you check if the SQL Server service is satarted and running fine (Not pinging) ?

    Thank You,

    Best Regards,

    SQLBuddy

  • September 16, 2011 at 6:57 am

    #1382523

    When I OFF the windows firewall on the machine,

    it worked . Now can connect to sql server and through telnet too.

    Huh.

    Guess the windows firewall icon popped up on that machine and someone put it ON.

    We didn't came to know about that change.

    Thanks a lot guyz.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 7 posts - 1 through 6 (of 6 total)

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