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
- Open the application; the dialog appears (or click Datacenter Selection).
- If the list is empty, click New and fill the four fields above.
- Click Test Connection.
- Click Save — the datacenter becomes selectable from the dropdown.
- 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.