Connecting to the SQL server

1. Start RMH Store Administrator. The shortcut should be available on your desktop.
2. Click Connect.
3. In the Server field, type the name of the server running your SQL server, or use the drop-down list to select the server. If you installed Microsoft SQL Server, Store Manager, and POS on the same computer, you can enter a period, (local), or localhost into this field.
4. Under Connection information:
  • Select Use Windows Authentication if all of your users and computers belong to a Windows domain and you want to use Active Directory to manage the account and password.

Note: While you can use Windows credentials to connect to the database, you will need to click Configuration and enter the SQL server credentials on the Database tab.

  • Select Use SQL Server Authentication if you want to use the SQL server to manage the account and password. Type the User name and Password for the SQL server.

Note: Some versions of SQL Server do not support SQL Server Authentication. If this applies to your SQL Server installation, you must select Use Windows Authentication.

5. In the Database field, type a temporary name for the database.
6. Click Connect.