question

JKontoyianni avatar image
JKontoyianni asked

Why Service_broker_guid of msdb changed unexpectedly

We have SQL EXPRESS 2014 at a client on WIN 10 PC. We use service_broker_guid of msdb as part of our software registration process. Any changes on the above guid will force our software to request registration over again.

The client does not know how to change the service_broker_guid nor do we give access to SQL server, but somehow every month or so the client calls for re-registeration of the software. In most cases the quid goes back and forth between 3-4 different guids.

What are the cases where SQL server will automatically change the guid on msdb database (i.e. without user intervention / or modifications on SQL Server)?

msdbservice-brokerguid
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

every month or so... does this coincide with a patching cycle?

0 Likes 0 ·
JKontoyianni avatar image JKontoyianni commented ·

Not really. It happened :

2019/10/9 Wednesday

2019/10/17 Thursday

2019/12/30 Monday

2020/01/17 Friday

2020/02/17 Monday

2020/03/12 Thursday

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.