Install the SQL Server to use as a database management system for PAtools.

  1. Execute SQL<year>-SSEI-Expr.exe.
  2. In the installation window, select Custom.
  3. Click Install.
  4. In the SQL Server Installation Center, select New SQL Server stand-alone installation or add features to an existing installation.
  5. Accept the licensing terms.
  6. Enable the Use Microsoft Update to check for updates (recommended) checkbox.
  7. On the Feature Selection page, click Unselect All, then enable Database Engine Services.
  8. On the Instance Configuration page, add SQLExpress<year> as a Named instance.
  9. In Server Configuration » Service Accounts, change the SQL Server browser to Automatic.
  10. In Server Configuration » Collation, ensure the Database Engine is Latin1_General_CI_AS.
  11. Use the Database Engine Configuration to complete the following steps.
    1. From the Server Configuration tab, select Mixed Mode and set your password.
    2. From the Server Configuration tab, select Add Current User to grant yourself administrator permissions.
    3. From the Memory tab, select Recommended and enable the recommended memory configurations.
    4. From the FILESTREAM tab, enable all three checkboxes.
  12. Click Next to complete installation.