Hi,
I am trying to run a remote procedure call between two linked sql servers and am receiving the following error:
"Could not relay results of procedure [OLE/DB provider returned message: Timeout expired]."
The remote query and login timeouts have been set to 0 (infinite) and yet I am still receiving the error message.
Are there any ways around this?
The properties of the SQL Server I am trying to access are as follows:
Data Access, RPC and RPC out are all checked,
Collation compatible and Use remote collation are not checked.
Connection Timeout and Query Timeout are both set tp 0.
Any help with getting around this would be extremely grateful.
Thanks
Start Free Trial