EXEC SP_CONFIGURE 'remote query timeout', 1800
reconfigure
EXEC sp_configure
 
EXEC SP_CONFIGURE 'show advanced options', 1
reconfigure
EXEC sp_configure
 
EXEC SP_CONFIGURE 'remote query timeout', 1800
reconfigure
EXEC sp_configure

Źródło: http://sqlserverplanet.com/troubleshooting/fix-timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding/