Configure the connection to SQL Server and the store database

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

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

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

2. Click Configuration.

1. In the Server Name field, type the host name of the computer where you installed SQL server, a backwards slash (\), and the name of the SQL Server instance.

If you installed Microsoft SQL Server, POS, and Store Manager on the same computer, you can enter a period, (local), or localhost into this field.

1. In the Database field, type the name of the store 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.