Post reply

Linked Server - SQL Server does not exist

  • October 23, 2006 at 5:25 am

    #61841

    All,

    Odd one here.  We have 2 servers (call them A & B) which were quite happily working up until 10.20pm last night.

    Server B has a linked server to Server A.  Last night, the 10.20 job fails with SQL Server does not exist or access denied.

    A quick check and the linked server connects using sa (not my design and in the process of change!!).  From Server B, I can ping Server A.  There are other servers which have the same configuration as Server B and they can still access Server A through their linked server.

    I tried registering Server A in Server B's enterprise manager - same error.  Tried the same on another server and it worked.

    There is also a linked server from Server A to Server B and I can query that no problem.

    Turns out, I can't actually register any server in enterprise manager or create a linked server from Server B.

    Bit stumped on this one now.  Fortunately it's a reporting box and not massively critical...Any idea's?

  • October 23, 2006 at 10:05 am

    #667407

    I guess that server A has some kind of Firewall and the server B was using TCP/IP to connect. And that port 1433 was open.  Or you were using named Pipes to connect and port 445 was open. Whatever. Now at some nice point somebody was creating an ODBC source, clicked on Client Configuration button in ODBC administrator and somehow changed the protocol.

    Please, note: if you change Client Configuration in ODBC source and then cancel ODBC source creation ot modification then client configuration will change anyway.

    To Check: open Client Network Utility from the Start menu or Start ->Run ->Cliconfg and check if there is an alias with server A name or IP. Check what protocol the alias is using - TCP/IP or Named Pipes. Create alias with a different protocol. Try to use it.

     

    Regards,Yelena Varsha

  • October 24, 2006 at 3:39 am

    #667514

    Hi Yelena,

    Thanks for the reply.  No firewall between the servers.

    It was a real odd one.  I ran a sp_who on Server A, but there was no spids from Server B.

    In the end we bounced Server A and then Server B started to work again.  Real wierd one, but it works and the users are happy again!

    Guess it was having monday morning blues

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

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