Issue

• Upgrade an MS SQL Server Express instance installed with ESET Security Management Center Server

Details

Solution

1. The ESMC Server version 7.x All-in-one installer uses SQL Express 2014 by default. To check which version of SQL Server you are using, check the error log located by default at C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Log\ERRORLOG and ERRORLOG.n. The version of MS SQL Server is specified in the first rows of the log.

Figure 1-1

1. Stop the ESMC Server Service.
    
2. Create a full database backup. We recommend that you specify a new backup set name. If you do not specify a new backup set name and the existing name has already been used, the new backup will be appended to the existing file and create an unnecessarily large backup file..
    
3. Depending on the type of media you will use for the upgrade, mount the SQL Server installation ISO or execute the installation package to launch the installation process.
    
4. In the SQL Server Installation Center window, click Maintenance → Edition Upgrade to launch a wizard to change your edition of SQL Server.

Figure 1-2
 

1. In the Upgrade the Edition window, type the product key and click Next.

Figure 1-3
 

1. If you agree with the license terms, select the check box next to I accept the license terms and click Next to continue the upgrade.

Figure 1-4
 

1. After passing the Edition Upgrade Rules checkup, you must specify the instance of SQL Server you would like to upgrade. From the dropdown menu, select the desired instance of SQL Server (ERASQL if you have used the default ESMC Server installation configuration) and check the list of installed instances below. Click Next to continue.

Figure 1-5
 

1. The wizard is now ready to upgrade. Verify the features that will be changed and click Upgrade.

Figure 1-6
 

1. Your SQL Server edition is now upgraded. To check the new version in the summary log, click the hyperlink in the wizard window, or repeat step 1 of this article to check the newest error log file.

Figure 1-7

1. Start the ESMC Server Service.

KB Solution ID: KB6732 |Document ID: 25434|Last Revised: August 16, 2018