DSN Setup

From the Windows Control Panel select Administrative Tools > Data Sources. Then select the System DSN tab.

Press the Add Button and highlight SQL Server.

Enter a name for the DSN, description and specify the SQL server to connect to. If DSN is the preferred method of communication: one connection per each server in the network needs to be established in all Workstations that will connect to SQL instances.

Do not change the method of authentication unless your IT department directs this be done. Accept the defaults in this dialog and click finish. System shows a summary of the DSN creation.