Windows: Create Datastore Data Sources for Microsoft SQL Server

Note: We recommend that you use a connection string to connect to Microsoft SQL Server databases; that is, using the connect attribute within the database configuration file, which is covered in Update the Configuration File for Microsoft SQL Server Datastores.

If you did not use connection strings when configuring the database configuration file, use the following steps to create ODBC data sources to access the datastore databases.

Open the ODBC Data Source Administrator.
Tip: On most newer Windows versions, click the Start Menu button, type ODBC, and then select the appropriate desktop app.
On the ODBC Data Source Administrator dialog box, select the System DSN tab.
Add the mandatory data sources:
Note: In order to create or query databases, you must have an active data source connection to the master database (the primary configuration database supplied with MSSQL). If this data source already exists, you can skip this step.
1. Click Add.
2. Select the appropriate ODBC driver for your database (for example, ODBC 17 for SQL Server is a common one for MSSQL), and click Finish.
  Note: The bitism of your driver must match the bitism of the application that will use it.
  
  The Create New Data Source... wizard appears.
3. Enter a name and description for the data source, and the name of the server on which the database will reside.
  The data source name should be the name as specified by dsn:<name> when updating the database configuration file for this database.
4. Click Next twice.
5. Select the Change the default database to: option, and enter master.
6. Click Next, and then click Finish.
  An overview of the data source details is displayed.
7. Click Test Data Source.
  The connection should be successful; if not, it indicates that you have a problem with your Microsoft SQL Server installation, and should consult the vendor instructions to troubleshoot before proceeding any further.
8. Click OK twice.
Add a new data source for each required datastore:
1. Click Add.
2. Select the appropriate ODBC driver for your database (for example, ODBC 17 for SQL Server is a common one for MSSQL), and click Finish.
  Note: The bitism of your driver must match the bitism of the application that will use it.
  
  The Create New Data Source... wizard appears.
3. Enter a name and description for the data source, and the name of the server on which the database will reside.
  The data source name should be the name as specified by dsn:<name> when updating the database configuration file for this datastore.
4. Click Next twice.
5. Select the Change the default database to: option, and if your datastore is to be housed in a single physical database containing other datastores/region databases, enter the name of that database as specified by -db|existdb:<db-name> when updating the database configuration file, or if the datastore is to be housed in its own database, enter the name of the database as specified by -name:<dsname> when updating the database configuration file.
6. Click Next, and then click Finish.
  An overview of the data source details is displayed.
7. Click Test Data Source.
  The connection should be successful; if not, it indicates that you have a problem with your Microsoft SQL Server installation, and should consult the vendor instructions to troubleshoot before proceeding any further.
8. Click OK.
  The ODBC Data Source Administrator appears again.
9. Repeat these sub-steps for each additional datastore you require.
Click OK.
The data sources for the datastores are configured.

The data sources for the datastore databases are configured. You can now start to upload data files to them using the dbfhdeploy command line utility.