I had deployed the extended store procedure on the SQL cluster and when I run 1st time extended store procedure ok. I tested the failover a few times and then run the again extended store procedure.

I hit the error as below:

The description for Event ID 0 from source xp_push cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Timeout error:XXX.XXX.XX.XXX on port 81. Error code 0

Hope to get advice whether I wrongly deploy or what else I miss out. Thanks

Did you put xp_push on a shared drive or local?

https://technet.microsoft.com/en-us/library/aa274529(v=sql.80).aspx

Remember that when you failover to another node, only shared volumes move to the new owner.

I hope you found this post helpful! If you did please vote it as helpful on the left. If it answered your question please mark it as the answer below. :)

• Edited by Daniel Janik 3 hours 46 minutes ago

Do I need to put the DLL file of the extended stored procedure into the shared drive or C drive of each active and passive server?

Thanks for your reply

Below is a quote from Daniel's link:

Using Extended Stored Procedures and COM Objects

When you use extended stored procedures with a failover clustering configuration, all extended stored procedures need to be installed on the shared cluster disk. This is to ensure that when a node fails over, the extended stored procedures can still be used.

If the extended stored procedures use COM components, the administrator needs to register the COM components on each node of the cluster. The information for loading and executing COM components must be in the registry of the active node in order for the components to be created. Otherwise, the information will remain in the registry of the computer on which the COM components were first registered. For more information, see the "Extended Stored Procedure Architecture" topic in the SQL Server 2000 32-bit Books Online.