June 10, 2021 at 9:34 pm
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:
June 10, 2021 at 10:08 pm
I'd start by checking the logs. Logs on the source and the destination servers. Both SQL and Windows logs.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 11, 2021 at 5:19 am
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
June 15, 2021 at 11:34 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply