Try to go to Server Properties -> Connections and check the Remote Query timeout parameter - change to 0 for unlimited and it should not time out anymore