Configure the connection to SQL Server and the Central database

This topic describes how to configure the connection to SQL Server and the Central database in Central Administrator.

You must restore or create the Central database prior to connecting to it. You can use a sample Central database to start. You can find sample Central databases under C:\Program Files (x86)\Retail Hero\RMH Central Manager\DBFiles.

1. Open Central Administrator. The shortcut should be available on your desktop.

2. Click Configuration.

1. In the Server Name field, type the host name or the IP address of the computer where you installed SQL Server, a backwards slash (\), and the name of the SQL Server instance if you are using a named SQL Server instance.

1. In the Database field, type the name of the Central database.

2. Select Use SQL Server Authentication.

3. Enter the User name and Password for the system account.

4. Click Test Database Connection. You should see the message Database successfully connected.

1. Click Save And Close.