I found the following article that says that you have to enable the service broker prior to adding the database to the AG. Some operations are not allowed on a database that is participating in a database mirroring session or in an availabilityĪDFS authentication for users is working fine, so I don't think the Service Broker and messaging capability it provides is essential for the ADFS authentication piece and may be for informational purposes. The operation cannot be performed on database 'AdfsConfiguration' because it is in a database mirroring session or an availability group.
Unfortunately, when I tried to enable the Service Broker using the SQL Query, I got the following error:
#MICROSOFT SQL SERVER DOWNLOAD 4.0 HOW TO#
I googled the exception details and found the above post on how to enable the Service Broker.ĪLTER DATABASE SET ENABLE_BROKER WITH ROLLBACK IMMEDIATEįrom the GUI: Right Click Database -> Properties -> Options -> Service Broker ->Set Broker Enabled to True The Microsoft JDBC Driver 4.0 for SQL Server download is available to all SQL Server users at no additional charge, and provides access to Microsoft SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, and SQL Azure from any Java application, application server, or Java-enabled applet. Some operations are not allowed on a database that is participating in a database mirroring sessionīut what is the solution to this problem? The operation cannot be performed on database "AdfsConfigurationV3" because it is involved in a database mirroring session or an availability group. Please enable the Service Broker for this database if you wish to use notifications.ĪLTER DATABASE AdfsConfigurationV3 SET ENABLE_BROKER with rollback immediate The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Take effect until the Federation Service restarts. However with AlwaysOn I can't enable it.įailed to register notification to the SQL database with the connection string Data Source= Initial Catalog=AdfsConfigurationV3 Integrated Security=True Min Pool Size=20 for cache type 'ServiceStateSummary'. I've got ADFS 4.0 up and running but it periodically complains about the SQL Service Broker not being enabled.
0 kommentar(er)
