Follow the below steps:
Go to Cortana search and type ODBC.
Select the ODBC Data Sources (64-bit).
Click on the System DSN tab.
Select SQL Server from the list of available data sources (it is usually the last option in the list).
Click on Finish.
Type in Name: & Description: aps_dsql and select or type in the SQL Server name you will be connecting to.
Click Next.
Select the radio button next to With SQL Server authentication….,
Type in the Login ID of admin. Click Next.
Note: If your site uses Windows NT Authentication, select that option instead.
Remove the ticks from the check boxes from: Use ANSI quoted identifiers and Use ANSI nulls, padding and warnings.
Click Next, then Finish.
Click on Test Data Source.
Once the data source has tested successfully click OK.
Click on OK to close the set up.
The Data Source should now show in the list, click OK.