linked server stopped working

  • sql server 2019, 4 linked servers which connect to other SQL Server just stopped working, one month back, I restarted the SQL Server and they worked fine again- But this is production, Any ideas other than restarting, I redid the SQL Server Linked Server but it did NOT work. I get LoginTimeut Expired or  A network and Instance specific error occured.

    I'm able to ping the destination server from Primary using hostname and IP Address.

    Thanks for your inputs:

  • I'd start by checking the logs.  Logs on the source and the destination servers.  Both SQL and Windows logs.

  • Also speak to your network security team they may have introduced firewalls between the servers and also the windows team if they have enabled or restricted the windows firewall

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

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