Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Service Broker Issue : Error getting enabled proto

Author  Topic  dbguy Starting Member 1 Post Posted - 2012-03-13 : 21:20:06 I am using service broker to make async calls to a stored procedure. I have a stored procedure ProcessTargetQueue attached to a TargetQueue. It calls another stored procedure ExtractData. The ExtractData run remote queries using OPENQUERY and fetch data from remote SQL servers. I created the queue using the below code CREATE QUEUE TargetQueue WITH STATUS = ON, ACTIVATION( STATUS = ON, PROCEDURE_NAME = <DBName>.dbo.ProcessTargetQueue, MAX_QUEUE_READERS = 25, EXECUTE AS OWNER ) I populate the queue using the procedure LoadAndProcessQueue. Whenever a message arrives in TargetQueue the procedure ProcessTargetQueue executed. But it throws an error message : SQL Server Network Interfaces: Error getting enabled protocols list from registry [xFFFFFFFF]. Thanks