Post reply

Linked Server Error

  • January 26, 2006 at 5:33 pm

    #67261

    I have 3 servers, all of them are linked together.

    SQL Server A, B C

    I recently have another SQL Server D created. I could successfully link with Server A, and B but when I try to connect to C I get an error 'SQL Server does not exist or login denied'. Morevoer A,B,C are already linked.

    I am able to create a link from C to D but not vice versa. I have tried several ways to do that but nothing seems to be working. Any thoughts???

    Thanks

    Viq

  • January 27, 2006 at 2:10 pm

    #617574

    Looks like a firewall or port  problem to me.

    See if you can connect from D to C by other ports: pinging, mapping a drive, register C in EM from D (not link but register)  etc

    Also do the following: try to change the protocol: create an entry in the client network utility on D for the connection to C and specify Named Pipes for the protocol, try to link again, then try TCP/IP for the protocol with Dynamically Determine Port.

    Also, if C has instances then SQL Browser service has to be enabled and port UDP 1434 open. 

    Regards,Yelena Varsha

  • January 27, 2006 at 2:54 pm

    #617582

    Hi,

    Thanks for the tip I first tried to register the server in EM, and as suspected it failed, with an error 'SQL server does not exist or login denied'.

    I can ping it though, it seems like a port issue I guess .

    Viq

  • January 27, 2006 at 3:55 pm

    #617592

    with port issues sometimes Named Pipes connection will work. Test it by creating Named Pipes alias from Client Network utility.

    Regards,Yelena Varsha

  • January 27, 2006 at 6:30 pm

    #617602

    By mentioning client Netowrk utility, do you mean while creating a ODBC connection select named pipe ?

    Viq

  • January 27, 2006 at 6:33 pm

    #617603

    OK never mind I found it.

    I will post reply if it worked.

    Thanks

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

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