Configuring the Data Link for Microsoft SQL Server

  To configure the data link for Microsoft SQL Server:

1. From Windows Explorer, double-click the UDL file that you created.

2. From Data Link Properties, select the Provider tab, and from the OLE DB Providers list, select Microsoft OLE DB Provider for SQL Server.

3. Click Next.

4. On the Connection tab:

   1. Enter the server name, which is the computer hosting the relational database.

   2. Select Use a Specific User Name and Password.

   3. Enter a username and password for a user with full access rights to the database.

      Note:

      You can use the default username sa. If you use the default name, leave the password text box blank, and select Blank Password. If you do not want to use the default username, you must enter the name of a user other than the default user who has full access rights. Ensure that this user is granted privileges to create, update, and delete tables.

   4. Select Allow Saving Password.

5. Select the database to which you want to connect.

6. Click Test Connection.

7. On the Test Connection Succeeded box, click OK.

8. Click OK to save the connection, and close the dialog box.

9. Right-click the UDL file, and select Open to set the selected UDL file as the system data link file.