Installation of Microsoft SQL Server Express 2012 SP2 guide.
As part of the Aspen Product Suites, the user is required (in most cases) to install Microsoft SQL Server Express 2012 SP2 as a prerequisite. AspenTech provides a copy of Microsoft SQL Server Express 2012 SP2 on the aspenONE Media. Below is a step by step guide to install the software.1. From the aspenONE Media, double click on the folder labeled “3rd Party Redistributables”. Your display should change to this:
2. Now you will need to open the “Microsoft SQL Express 2012 SP2” folder and double click “SQLEXPR_x64_ENU.exe” to start the installation.3. Click the “New SQL Server stand-alone installation or add features to an existing installation” link.
4. Accept the license terms and click Next.
5. The installer will scan for product updates and install the setup files automatically.
6. Leave the default features selected as shown below, and click the Next button.
7. Enter a name for the SQL Instance or use the default “SQLExpress”. After inputting this information, click the Next button.
8. Use the default server configuration settings and then click the Next button.
9. Select the “Mix Mode” option and type in a password for the sa (System Administrator) account. Aspentech recommends using the password of Aspen100. Click the “Add Current User” button to add yourself as a backup administrator in case you forget the System Administrator password. Click the Next button.
10. On the Error Reporting screen, leave the checkbox to send reports to Microsoft unchecked, and click the Next button.
11. The installation will begin.
12. Once the installation is complete, click the Close button.
You have now successfully installed Microsoft SQL Server Express 2012 SP2 and you are prepared to continue with the installation of the Aspen products. If you have encountered any issues, please contact Aspentech Support at 1-888-996-7100 taking options 5 then 1.
SQL Server Express, Installation guide