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

From AutoCount Resource Center
Jump to navigation Jump to search

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


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

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations