Installing Simphony Database Components on Microsoft SQL Server

When installing Simphony with Microsoft SQL Server, you cannot install the databases from a remote machine; you must run the Simphony database setup on the local database servers and install the database components.

Beginning with the Simphony 2.10 release and later, you can upgrade application components on servers with or without downloading CAL Packages to the Simphony database. This flexibility can speed the upgrade process on properties using multiple application servers.

1. Run the Setup file, and then click Next to continue the installation.
2. Select Database Components Only, and then click Next.
3. Select MS-SQL as the database platform type, and then click Next.
4. Enter or select the location to install Simphony, and then click Next twice.

   Oracle recommends that you install the Simphony application on a separate partition from where the Microsoft Windows operating system resides.

5. To install Simphony with a blank database:
   1. Select Blank Database.
   2. Enter a strong Username and Password to comply with Payment Card Industry (PCI) security guidelines.

      The credentials that you enter here are used to create the Simphony super user to access the EMC.

   3. Confirm the password, and then click Next.
6. Enter or select the location to create the transaction database data files, and then click Next.

   List of Simphony Database Configuration Fields contains more information on the database setup options.

7. Enter the information to configure the transaction database, and then click Next.
8. Enter the credentials for the SA user, and then click OK.
9. Enter or select the location to create the security DB data files, and then click Next.
10. Enter the information to configure the security database, and then click Next.
11. Click Confirm.
12. After the installation completes, click Finish to exit the Simphony setup.