sql server: service broker is administratively disabled

I fixed it after reviewing and resetting all broker related database IDs.

The first thing I did was see what we have (both on the source and destination servers):

--=====================================================================
-- checking what we have and where we point to
--=====================================================================
SELECT @@SERVERNAME
-- my_target_server

USE (master)
GO
SELECT   (name)
 ,(is_broker_enabled) 
 ,(service_broker_guid)
FROM (sys).(databases) 
WHERE 1=1
  AND is_broker_enabled = 1
ORDER BY  NAME
GO

SELECT name,is_broker_enabled,service_broker_guid, is_trustworthy_on FROM sys.databases
order by 2 desc, 3 desc,  1

I saw that the broker ID needed to change:

--CD718202-CB34-4DCD-BADC-7800C5F2FF3D
  ALTER DATABASE ORCASTG SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE  
  ALTER DATABASE ORCASTG SET NEW_BROKER with rollback immediate
  ALTER DATABASE ORCASTG SET trustworthy on with rollback immediate

Sorry for the trustworthy, this is how it was configured and I never changed it.

on the destination server:

enter the image description here

on the origin server:

enter the image description here

So I have changed the Service Broker identifiers inside the routers.

--targer server 
USE (cola)
GO
IF  EXISTS (SELECT * FROM sys.routes WHERE name = N'rou_ORCARoute')
DROP ROUTE (rou_ORCARoute)

CREATE ROUTE (rou_ORCARoute)   
WITH  SERVICE_NAME  = N'svc_SendStatusChangeService' ,  
BROKER_INSTANCE  = N'CD718202-CB34-4DCD-BADC-7800C5F2FF3D' ,  --BROKER ID OF ORCASTG
ADDRESS  = N'TCP://mysourceserver.mycompany.com:4022' --IP address of my source server
GO

--source server     
USE (ORCASTG)
GO
IF  EXISTS (SELECT * FROM sys.routes WHERE name = N'rou_CAUKRoute')
DROP ROUTE (rou_CAUKRoute)

CREATE ROUTE (rou_CAUKRoute)   
       WITH  SERVICE_NAME  = N'svc_receiveStatusChangeService' ,  
       BROKER_INSTANCE  = N'452711F3-60CD-47E6-BFA4-3BD8C9D6AB56' ,   --BROKER_ID OF COLA  
       ADDRESS  = N'TCP://mytargetserver.mycompany.com:4022' --IP address of my target server
GO

Even after putting the correct boker_ids for the databases in the previous routers, I still did not receive any communication.

I had to check the routers, I noticed that I was using IP addresses instead of the names of the servers, and that worked fine, but we made some changes to our domains and that no longer worked, so using the test below, I first identified that was no longer working (connectivity), then changed it accordingly using server names.

 declare @sql varchar(1008)
 set @sql = 'powershell.exe -command Test-NetConnection 200.1.0.198.:4022'
 EXEC xp_cmdshell @sql

enter the image description here

After those changes, everything started working fine.

enter the image description here

Any Forex broker (or similar) with no overnight fees for Bitcoin?

Does anyone know of something like a Forex broker that I can use to invest in Bitcoin with no overnight fees? I just want to buy and then sell in a few months, maybe more than a year. If this can only be accomplished by not using leverage then I am happy with that.
Thank you!

architecture: what is the relationship between message broker and message oriented middleware?

https://en.wikipedia.org/wiki/Message_broker says

A message broker (also known as an integration broker or interface engine (1)) is a broker software program module that translates a message from the sender's formal messaging protocol to the recipient's formal messaging protocol. Message brokers are elements in telecommunications networks or computers where software applications communicate through the exchange of formally defined messages. (one) Message brokers are a basic component of message-oriented middleware (MOM), but are generally not a replacement for traditional middleware like MOM and remote procedure call (RPC).

https://en.wikipedia.org/wiki/Message-oriented_middleware says

Message-oriented middleware (MOM) is a software or hardware infrastructure that allows messages to be sent and received between distributed systems.

The main disadvantage of many message-oriented middleware systems is that require an additional component in the architecture, the message transfer agent (message broker). As with any system, adding another component can lead to reductions in performance and reliability, and can also make the overall system more difficult and expensive to maintain.

What is the relationship between the message broker and the message-oriented middleware?

  1. What do "message brokers are a basic component of message-oriented middleware (MOM)" and "but are not normally a replacement for traditional middleware like MOM" mean? Does it mean that a component of something cannot be a replacement for that something?

  2. Is Message Broker a message-oriented middleware component? What other components does message-oriented middleware have?

  3. Is it correct that the message broker and message-oriented middleware can be

    • message queue,
    • publish-subscribe, or
    • both of them?

Thank you.

How do I know which is the best forex broker? – Discussions and help

TopGold Forum is fast becoming the leading online finance destination on the Internet.

We are a premiere authority forum destination for professional investors, currency traders, affiliates, and individuals who want to make a living online or just make more money.

If this is your first visit, be sure to check out the frequently asked questions by clicking the link above. You must register before you can post: click the registration link above to continue.

When choosing a broker

When choosing a broker, there are many things to check. Of all trading instruments, spreads are primarily seen as an important financial tool that an investor should consider when choosing a broker. I chose LQDFX in my trading career from my first trading day due to the lower trading spreads of 0 pips, which is very helpful in making profit using any type of speculative trading techniques that generate profits in no time . So, my commercial life is very comfortable.

Choose the right broker

In currency trading, each trader must choose the correct broker that is most appropriate for the trade to be used. In case you like scalping, you must choose the broker that allows scalping. As a reseller, I am now with XeroMarkets, which is a true STP execution trading platform and resale licenses that include the majority of the minimum trading margins of 0.1 pips. By using these safer commercial spreads, I am configured for the scalp without inhibitions until the end of time. It also offers a leverage of up to 1: 500.

World famous and global Forex broker – Discussions and help

TopGold Forum is quickly becoming the main online finance destination on the Internet.

We are an authority and premiere forum destination for professional investors, currency traders, affiliates and individuals who want to make a living online or simply earn more money.

If this is your first visit, be sure to check the frequently asked questions by clicking on the link above. You must register before you can publish: click on the previous registration link to continue.

Instaforex Broker $ 2,000 Forex / Binary options No deposit bonus

What makes InstaForex a good option is that it is a reliable binary options trading platform, so the operator would not have to fear anything if he decides to choose this platform. They offer a 24/7 consulting service. Exclusive online support makes it easy for the operator to get all the help he has been looking for so far. This means that if the merchant has any questions, he can prepare it to come up with a solution to his problems. InstaForex offers commercial binary options in currency pairs, cryptocurrency pairs, metals and CFDs in stocks.

https://binaryoptionsfree.eu/review/instafo…-deposit-bonus/

USGFX – Best Australian Broker – Forex Brokers

TopGold Forum is quickly becoming the main online finance destination on the Internet.

We are an authority and premiere forum destination for professional investors, currency traders, affiliates and individuals who want to make a living online or simply earn more money.

If this is your first visit, be sure to check the frequently asked questions by clicking on the link above. You must register before you can publish: click on the previous registration link to continue.

FXDirects Broker

FXDirects is a FMRRC regulated broker that offers 100: 1 high leverage facilities, narrow trading margin and superior rapid execution. They use a segregated bank account of the National Bank of England to ensure high financing security and maintain first level liquidity. Easy commercial execution with the broker is possible due to its intelligent bridge technology.