Tutorials

SQL Server DSN

There are eight steps to setting up a DSN connection to a SQL Server database, if you include the steps for testing the connection.

Each of the steps below have an image associated with them in case you need to see that you are looking at the right screen as is being described. To view the image, just click the <image> link.

Steps:

1. Select SQL Server from the add new DSN list and click Finish. <image>

2. Type the DSN name in the Name box, leave the description blank, select the SQL Server from the drop down list and click Next. <image>

3. Select your authentication method and click Next. <image>

4. Select your database as the default database and click Next. <image>

5. Adjust the language, translation and log settings as appropriate (default is usually okay) and click Finish. <image>

6. Check your settings as displayed. Click Test Data Source if it all looks good. (If you need to change anything, click cancel, then back). <image>

7. Click OK to close the test success window. <image>

8. Click OK on the Add DSN dialogue box (your new DSN will be listed in there).