DotShoppingCart - Error After Windows Update

	My Cart Log In Register
	an ASP.NET Open Source CMS & eCommerce platform Search:
Home Open Source Edition DotShoppingCart Suite Services Support Blog Marketplace Buy Forums Video Tutorials Documentation Premium Support Submit Support Ticket

Home > DotShoppingCart Forums > Support > Installation > Error After Windows Update

Error After Windows Update

Last Post 4/8/2009 3:48:41 PM By Bahram. 4 replies.

4/8/2009 11:20:44 AM
Bahram Posts: 878 Joined: 12/8/2008 Location:Vancouver, BC Canada website	Error After Windows Update
	Hi Luke, This error occured after Windows Update or after a Database Detach/Attcah, Please let me know How to fix this. Message : The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.

4/8/2009 1:35:34 PM
lukezy Posts: 2109 Joined: 6/12/2007 Location:WA, US website	Re: Error After Windows Update
	The exception message is very clear. Go look at SQL book online on how to enable service broker for the database. DotShoppingCart Staff

4/8/2009 2:32:45 PM
Bahram Posts: 878 Joined: 12/8/2008 Location:Vancouver, BC Canada website	Re: Error After Windows Update
	Should the Service Broker be activated on the Database, Why it did not ask until now? Actually It is not due to Windows Update..... I had a Detach/Attach and copy database ..................

4/8/2009 2:49:37 PM
lukezy Posts: 2109 Joined: 6/12/2007 Location:WA, US website	Re: Error After Windows Update
	It was activated if you ran InstDSC.exe. After backup/restore or attach/detach, you will have to re-enable it. As reason for why, you will need to ask Microsoft SQL server team. My guess is security reason. DotShoppingCart Staff

4/8/2009 3:48:41 PM
Bahram Posts: 878 Joined: 12/8/2008 Location:Vancouver, BC Canada website	Re: Error After Windows Update
	I made a copy of V3 database, run migration script and now executing this command : ALTER DATABASE [DBname_3.1] SET ENABLE_BROKER it never stops. I want to make sure that migration script is not the cause of this problem and only Datach database was.