Login timeout expired LinkedServer SQL

I had a database crash, after restoring it my linked queries which were working perfectly fine started to give this error Login timeout expired An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. I spent quite a bit of time on it but couldn’t find the cure. Eventually found this stackexchange post ¬†which sort of put me in right direction. The answer says SQL Agent will use Shared Memory to connect to…

Read More