Installing Gift and Loyalty on Microsoft SQL Server Database

  1. If you are upgrading the Gift and Loyalty database from 7.0.1 or older, stop all applications, servers, and databases connected to the database that you are upgrading.
  2. Extract DBInstall.exe from the installation file archive to the Gift and Loyalty database server. Do not extract the file to a folder structure that contains spaces. You can extract the file to another server and run the installation wizard using a network connection.
  3. Double-click DBInstall.exe to launch the database installation wizard.
  4. On the Choose Installation or Upgrade page, select whether you are upgrading an existing database or installing a new shell database.

    If you are installing a new shell database, install a clean Microsoft SQL Server with no Gift and Loyalty objects.

  5. On the Choose Install Set page, select iCare.
  6. On the iCare Database Information page, set up the Gift and Loyalty database:
    1. Select SQL Server.
    2. Enter the network port used by the database server. The default port is 1433.
    3. If you are performing an upgrade, in the Upgrade Login and Upgrade Password fields, enter the login credentials to the existing Microsoft SQL database server.
    4. In the Additional Connection Parameters field, enter any required connection strings.
  7. On the Pre-Installation Summary page, click Install and allow the database installation or upgrade to complete.
  8. Review the log file in C:\Temp\DBInstaller.log to verify that the installation finished without any errors.

Related Topics