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

Restore SQL Server 2005 Master Database

[SQL Server 2005 master Database Download 700 KB] You are running SQL Server 2005, your master database has got corrupted because of sudden power failure or other reasons. The SQL Server will not start. You have tried registry setting, playing with changing protocol, disabled via protocol but nothing worked. Do do not have backup of the masters, there is no way you can start your server, you are on the versge of loosing all you precious data. Do not panic, you can recover it by copying a fresh master.mdf file but there are tricks so please read on. 1. The…

Read More