This was really helpful guys. Thanks. But I am stuck with this error now

OLE DB provider "SQLNCLI" for linked server "MISSERVER" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for...