If the machine is 32 bit machine create an ODBC driver through Data Sources in Administrative tools.
If the machine is 64 bit then use the ODBC administrator in c:\windows\syswow64 folder (ODBCAD32.exe).
The follow these steps:
Navigate to the system DSN tab. Click the Add button.
Select SQL Server and click Finish.
Enter a name for the data source (Typically DeltaWMS) and the Server on which Delta is installed.
Ensure Windows NT Authentication is specified and check the ‘Connect to SQL Server…’ option.
Change the default database to the database for Delta (Typically DeltaWMS)
Accept the defaults on the next page and click Finish.
In the resulting window confirm the details entered and click ‘Test Data Source…’
The test should display as completing successfully.