No announcements
-
6 VotesAnnouncing Service Broker External Activator
The Microsoft SQL Server Service Broker External Activator (EA) is distributed in the Microsoft SQL Server 2008 Feature Pack. It is an extension of the internal activation feature and lets you move ...Sticky | 13 Replies | 52076 Views | Created by junan - Friday, November 21, 2008 6:24 PM | Last reply by davidbaxterbrowne - Tuesday, January 15, 2013 4:20 PM
-
0 Votes
Trying to follow a SQL Service Broker Step By Step configuration, what am I missing?
I've never used SSB before and is looking to implement this due to an issue we recently had with long running queries executing from a trigger. I'm following the guide below. Looks ...Unanswered | 3 Replies | 168 Views | Created by ARPRINCE - Tuesday, December 24, 2019 5:20 PM | Last reply by Erland Sommarskog - Tuesday, December 24, 2019 7:53 PM -
0 Votes
Service Broker External Activator Issue
Hi All, I am trying to configure service broker external activator service on SERVER2 ,in my database server (SERVER1) i have two installations of sql server one is 2012 and another ...Unanswered | 4 Replies | 2949 Views | Created by aruntb - Wednesday, January 16, 2019 5:44 PM | Last reply by GoranKaljevic - Thursday, December 12, 2019 5:50 PM -
0 Votes
The session keys for this conversation could not be created or accessed. The database master key is required for this operation. Error
Hi, I'm getting the following error In sys.transmission_queue in the transmission_status column "The session keys for this conversation could not be ...Answered | 2 Replies | 9994 Views | Created by ti2 - Friday, January 20, 2012 5:13 PM | Last reply by panlondon - Thursday, December 12, 2019 10:22 AM -
0 Votes
Service brocker master key error after db refresh
Error details Please create a master key in the database or open the master key in the session before performing this operation.Answered | 2 Replies | 867 Views | Created by Liju Lalithangathan - Friday, November 1, 2019 6:15 AM | Last reply by Liju Lalithangathan - Monday, November 4, 2019 6:18 AM -
1 Votes
Is service broker a good option?
Hi, I am developing a solution where an external app (.net based) at different client locations would upload CSV files in a queue and SQL server would then pick those files (from ...Unanswered | 1 Replies | 962 Views | Created by mr_super_genius - Monday, October 14, 2019 5:20 AM | Last reply by Erland Sommarskog - Monday, October 14, 2019 9:52 PM -
0 Votes
Single message stuck in transmission queue
I have single message that will not send in a transmission queue. All other messages of that type work fine. Only error I see is Connection attempt failed ...Unanswered | 3 Replies | 1598 Views | Created by PantsStatusZero - Tuesday, August 20, 2019 11:43 PM | Last reply by PantsStatusZero - Monday, September 9, 2019 5:21 AM -
0 Votes
How should I encrypt/decrypt a TCP/IP data stream ?
I am working on a project which will provide a TCP/IP data stream which will be encrypted on arrival in SQL Server. What would be a good way to decrypt the data stream in SQL Server ...Unanswered | 3 Replies | 1155 Views | Created by Randy Seedle - Wednesday, September 4, 2019 6:10 AM | Last reply by Tom Phillips - Wednesday, September 4, 2019 3:44 PM -
0 Votes
Service broker doing stuff when I don't want it to
Hello, I have recently implemented a Service Broker solution for asynchronous triggers. It seems to work well, but I have a question. We have ...Unanswered | 3 Replies | 1363 Views | Created by dylbud - Monday, August 5, 2019 3:38 PM | Last reply by Dan Guzman - Monday, August 5, 2019 6:51 PM -
0 Votes
Extracing SQL Service Broker Error Fields
I am creating some error handling for the `'SQL/ServiceBroker/Error'` `MessageType` within my queues `Activation Stored Procedure`. While, I have information on how to access the following ...Unanswered | 2 Replies | 2624 Views | Created by Prisoner Z3RO - Monday, January 7, 2019 4:59 PM | Last reply by kjmackey - Friday, July 5, 2019 3:24 PM -
0 Votes
Service broker with multi-subnet
We have a sql server multi-subnet environment with Always On availability groups as our high availability solution. And we'd like to use Service Broker over it. Do you see any issues with this ... -
0 Votes
SQL
My personnel computer is locked out after 2 minutes The people say I must buy a card for 200 or more dollars. What can I do about this??Unanswered | 1 Replies | 1954 Views | Created by BobKer - Saturday, June 8, 2019 4:26 PM | Last reply by Visakh16 - Sunday, June 9, 2019 8:41 AM -
0 Votes
Service Broker and Service Broker and is_trustworthy_on
I use the Service Broker to execute a stored procedure asynchronously simultaneously, using such a queue: CREATE QUEUE MyQueue WITH STATUS=ON , RETENTION=Off , ACTIVATION ...Answered | 6 Replies | 3509 Views | Created by Geri_Reshef - Wednesday, August 5, 2015 5:08 AM | Last reply by Erland Sommarskog - Thursday, May 23, 2019 9:47 PM -
2 Votes
The target service name could not be found. Server version compatibility problem?
Hi, I have two remote SQL Servers. One initiator another one is target. Now I need to move target to new server and new database just with SAME database ...Unanswered | 2 Replies | 1830 Views | Created by Natip - Friday, May 10, 2019 2:49 PM | Last reply by Natip - Monday, May 13, 2019 11:05 AM -
0 Votes
Replictaing data to multiple instance
Hi everyone, I have two below questions regarding service broker, I would appreciate if someone help me on those. 1- Is it possible to replicate data from one sql ...Unanswered | 1 Replies | 2503 Views | Created by Mourmansk - Friday, March 29, 2019 6:37 PM | Last reply by Hilary Cotter - Friday, March 29, 2019 8:18 PM -
0 Votes
An entity of type service cannot be owned by a role, a group, or by principals mapped to certificates or asymmetric keys.
I'm using SQL Server 2008 R2 and a WCF service in Visual Studio 2010. I am trying to set up a SQL Dependency to detect changes in the database, and I have set up a queue and service. I keep getting ...Answered | 11 Replies | 5643 Views | Created by Lane95 - Monday, August 8, 2016 7:06 PM | Last reply by Lane95 - Tuesday, February 26, 2019 9:07 PM -
0 Votes
Service Broker Waitfor Receive and Activation Procedure
Can anyone explain this concept to me: In Service Broker (SQL Server) a queue can be configured with an "activation" procedure. This is a procedure ...Answered | 5 Replies | 3096 Views | Created by dylbud - Thursday, November 29, 2018 7:46 PM | Last reply by dylbud - Friday, November 30, 2018 11:27 PM -
2 Votes
No enabled application monitor is on behalf of queue...
Hello, I am trying to set up external activation, and the external application doesn't ever seem to be launched. I get the following error, which shows up in the ...Answered | 4 Replies | 16901 Views | Created by Mark Shoemaker - Tuesday, October 27, 2009 2:17 PM | Last reply by Hugh C Jones - Wednesday, November 28, 2018 10:04 AM -
0 Votes
Broker:Connection_Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67__
I am trying to send a message between 2 different instances in the same domain.I am getting the above error.The SQl Server is logged on as NTService\MSSQlSERVER in both the instance.I am not ...Unanswered | 4 Replies | 2818 Views | Created by RobinThomas8687 - Monday, November 19, 2018 9:41 AM | Last reply by RobinThomas8687 - Tuesday, November 20, 2018 1:36 AM -
0 Votes
Connection attempt failed with error: 10060
I used the example "Completing a Conversation Between Instances" from SQL Server 2008 Books Online, but when I try to send a message, it does not go through, and in ...Answered | 13 Replies | 46557 Views | Created by dr938 - Monday, October 20, 2008 7:12 AM | Last reply by RobinThomas8687 - Monday, November 19, 2018 8:48 AM -
0 Votes
SERVICE BROKER ENDPOINT WITH CERTIFICATION
Hi All, How do we use SERVICE BROKER ENDPOINT FOR 2 SQL INSTANCES ON SAME SERVER . How do we migrate the ENDPOINT WITH CERFICATE FROM SQL SERVER 2008 to SQL SQL ...Unanswered | 1 Replies | 3087 Views | Created by Vanchan007 - Saturday, October 27, 2018 8:35 AM | Last reply by Erland Sommarskog - Tuesday, October 30, 2018 10:39 PM - Items 1 to 20 of 1908 Next ›
No announcements
