On each client computer connecting to a SQL server database, perform the following steps to set up a DSN:
Enter a logical name as this name appears as the database name in the logon screen.
If user(s) using the DSN to access the SQL Server database are connecting with non-native credentials, select the With Windows authentication using the network login ID option.
If user(s) using the DSN to access the SQL Server database are connecting with native authentication, select the With SQL Server authentication using a login ID and password entered by the user option. Make sure the Connect to SQL Server to obtain the default settings for the additional configuration options check box is checked. Type the users native SQL Server logon credentials in the Login ID and Password text boxes.
The ODBC Data Source Administrator dialog box reappears. The newly created data source appears in the System Data Sources list.