Datacenter Selection

Pick or create the SQL Server database this client should talk to.

Pick the right database

A "datacenter" is just a named SQL Server database. Most installations have one (your live production data), but it is common to have a second one for testing or a third for archive years. The Datacenter Selection dialog appears the first time you launch and any time you click Datacenter Selection from the login screen.

Fields you will see

  • Datacenter name — the friendly label (for example MainBranch_Live, HeadOffice_Test).
  • Server — the machine name or IP of the SQL Server. For LocalDB this is (localdb)\MSSQLLocalDB.
  • Database — the name of the SQL Server database attached for this datacenter.
  • Test Connection button — click before saving. You should see "Connection Successful".

Typical workflow

  1. Open the application; the dialog appears (or click Datacenter Selection).
  2. If the list is empty, click New and fill the four fields above.
  3. Click Test Connection.
  4. Click Save — the datacenter becomes selectable from the dropdown.
  5. Highlight the datacenter and click Select to proceed to the login screen.
Tip — Add a "Test" datacenter pointing to a copy of your live database. Power users can try new workflows there without risk to real data.