Troubleshooting: Upgrade error: SQL Server Service Broker is not enabled

Question: Failed to upgrade AutoCount, message: "SQL Server Service Broker for the current database is not enabled" was prompted.

Version: 1.8 / 1.9 / 2.0

Sql service broker.png


Possible Reason:

This problem is caused by the broker setting in SQL.


Solution:

1. To solve the issue, go to SQL Management Studio. (install SQL Management Studio if you have not installed it), click Database.


Sql service broker sql management.png


2. Then, select the database name and then right click to select Properties.


Sql service sql management 2.png


3. Next, click on Options.


Sql service sql management 3.png


4. Next, under Service Broker, change Broker Enabled from False to True.


Sql service sql management 4.png


5. Then, click on OK. Now, try to login AutoCount and upgrade the database again.


By:Hui Yan 170615; P170801

Go to menu

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations