question

Saxe6769 avatar image
0 Votes"
Saxe6769 asked ErlandSommarskog commented

How to start a SQL service in SQL Management Studio \DB\Service Broker\Services

Found this article https://social.technet.microsoft.com/Forums/en-US/29516d96-6b3a-47de-abd4-97d3f1a4ee83/configuration-manager-alerting-never-triggered?forum=configmanagergeneral&prof=required

and the solution was

"Update 3: Problem solved! The "AlertVariableChangeTargetService" in SQL Service Broker wasn't running. It probably happened during the SCCM upgrade we did recently or the SQL server upgrade we did before the SCCM Upgrade. You can check these Services in SQL Server Management Studio, then: Databases > CM_XY1 (SCCM Database) > Service Broker > Services"

but how to do that? If i check this service on our database it says "closed"


mem-cm-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Saxe6769, welcome to Microsoft Q&A! Does the SQL Service cannot start on your side? And is there have any error message? Could you please give us more details?

0 Votes 0 ·

Hi Carrin,

thanks for replying.

have you checked the link? I have an error message in SCCM (Endpoint Protection Manager failed to generate alerts for type:"31". Verify that the site database is configured correctly. Error code returned is:"0x87d20002".) and this brought me to the technet article which says check for service "AlertVariableChangeTargetService" in SCCMDatabase\Service Broker\Services and i just want to know if it says closed is it linke service is stopped or just waiting for running like a manual service?

Regards Sascha

0 Votes 0 ·

I can't say whether Carrin read the link or not, but if he did, he may not have made much sense out of it. Just like me, Carrin specialises in SQL Server, but you are asking a question about SCCM., which we know little about. I would recommend that you edit the tag for your question.

0 Votes 0 ·

Hi @Saxe6769, yes, I read the link which you provide, and I cannot see any error about SQL Server. Your question is related with SCCM, so I added a new tag and remove sql-server-general. You can find all products that supported on Q&A forum from this link.

0 Votes 0 ·
Saxe6769 avatar image
0 Votes"
Saxe6769 answered ErlandSommarskog commented

Hi Carrin and Erland,

thanks for your answers, my thoughts were that these services are specially for SCCM but there are may other services which should work the same way under Service Broker in SQL.

For example, you have service on every windows device, if you open services.msc you dont need to know what "computer browser" stands for if you just want to stop, start or restart this service. You can do the same commands for every other service [mostly :)]

Regards Sascha

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

A "service" in Windows has no relation to a "service" in SQL Server Service Broker.

Service Broker is asynchronous messaging system and it can be distributed over many servers. A service is a kind of an endpoint for a conversation of message. A conversation is between two services. All services has a queue associated with them.

You don't start services, you start (well "enablee") the queues. Although normally queues are running, but they can be disabled if there are five consecutive rollbacks on the queue. Usually that is due to a so-called poison message that you need take out of the queue to get things working.

0 Votes 0 ·
AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

Hi, @Saxe6769
Thank you for posting in Microsoft Q&A forum.
I see the queue is corresponding to the services under Service Broker, you may try to enable the queue "AlertVariableChangeTargetQueue".
106591-3.jpg


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



3.jpg (66.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Saxe6769 avatar image
0 Votes"
Saxe6769 answered

Queue is already enabled, so i am waiting for some SCCM experienced user who can answer that question

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.