Solved

configure service broker on all databases

Posted on 2016-10-18
2
98 Views
Last Modified: 2016-11-02
Hello,

Is it possible to configure service broker on all databases during the setup and not setting it on model database?

Thanks

regards
0
Comment
Question by:bibi92
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
ID: 41850183
Service broker (the service) by itself is available to the entire server. Whether a database can consume the service is governed by whether it has been enabled on the database or not.

The service broker identifier for each DB, the message types, contracts, queues, services, and stored procedures for the service are owned by the database - not by the server. Hence, you cannot have a central configuration at setup time - it needs to be done for each database.
0
 

Author Closing Comment

by:bibi92
ID: 41871154
thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
encrypt SQL Server 2008 port 1433 3 44
Help with SQL pivot 11 47
Moving away from Access 2003 adp files 4 45
VMware PVSCSI SQL Server 2016 AlwaysOn 2 34
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question