Others: How to upgrade from SQL Server Express edition to Standard edition

From AutoCount Resource Center
Jump to navigation Jump to search

Question: How to upgrade from SQL Server Express Edition to Standard (Runtime) Edition?


Answer:

Step 1: Browse to your SQL Server Standard Edition Setup folder and double click on “setup.exe”.

Note: You may contact our dealer to get the SQL Server Standard Edition setup file. There will be charges on the purchase of Standard edition.


Htusql1.png


Step 2: In SQL Server Installation Center, navigate to Maintenance and then click on Edition Upgrade.


Htusql2.png


Step 3: Click on Show details to investigate the error if there is any failed rules. Otherwise, click on OK.


Htusql3.png


Step 4: Click on Show details to investigate the error if there is any failed rules. Otherwise, click on Next.


Htusql4.png


Step 5: Enter the Product Key and click on Next.

Note: You will get the Product Key after you purchased the SQL Server Standard Edition from us.


Htusql5.png


Step 6: Check the checkbox of I accept the license terms and then click on Next.


Htusql6.png


Step 7: Select the specific SQL instance that you want to upgrade (e.g. A2006) and then click on Next.


Htusql7.png


Step 8: Click on Show details to investigate the error if there are any failed rules. Otherwise, click on Next.


Htusql8.png


Step 9: Click on Upgrade and wait for upgrading process.


Htusql9.png


Step 10: Click on Close to finish the upgrade process.


Htusql10.png


Your specific SQL Server Instance is now upgraded to Standard Edition.

There are 2 methods you can use to check the SQL Server Edition.


Method 1: Check the SQL Server Edition using AutoCount.

Go to Help > About AutoCount Accounting.


Htusql11.png

Htusql12.png


Method 2: Check the SQL Server Edition using SQL Server Configuration Manager.

1. Open up SQL Server Configuration Manager from your Start Menu, then under SQL Server Services, right click on your SQL Server instance and click on Properties.


Htusql13.png


2. Go to Advanced tab, scroll down and look for Stock Keeping Unit Name.


Htusql14.png


Note: Cross-platform upgrade is not supported. E.g. 32-bit instance of SQL Server to 64-bit instance of SQL Server. Cross version instance upgrade is not supported as well due to different database engine architecture. E.g. SQL server 2008 to SQL Server 2016.


By: CY 170921, KM 171005, P171020


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