Configuring CAPS with a Microsoft SQL Server Database

1. Navigate to the directory containing the CAPSConfigurator folder.
   Depending on your configuration method, the path is one of the following:

   • [Drive Letter]:\ MICROS\Simphony2\Tools\CAPSConfigurator

   • [Drive Letter]:\ MICROS\Simphony\CAPSonIIS\Tools\CAPSConfigurator

2. Double-click CAPSConfigurator.exe, enter the server and port number of the Egateway, and sign in using your EMC credentials. A list of Service Hosts appears.
3. Click the Service Host to configure.
4. Click CAPS Schema.
5. Enter the appropriate information in the CAPS Schema dialog, and then click Next.

   • Database: Select the SQL Server database type.

   • Server: Enter the server name.

   • Port: Enter the port number.

   • CAPS DB: Enter a name for the CAPS database.

   • Admin User: Enter the administrative user name used to connect to the database server.

   • Password: Enter the administrative password.

6. Enter the credentials to create a new database user for the CAPS database, and then click OK.

   • User Name

   • Password

   • Confirm Password

   A message indicates success.

   The CAPS Schema dbsettings.xml is configured at one of the following directories (depending on your configuration):

   • [Drive Letter]:\MICROS\Simphony2\IISCAPSServiceHost

   • [Drive Letter]:\MICROS\Simphony\IISCAPSServiceHost