Configuring the SQL Server ODBC Driver for Microsoft SQL Server

Use the following procedure to configure a data source name for your Data Source database using the SQL Server driver. Then repeat the procedure to configure a data source name for your OLAP Metadata Catalog database.

Note:

You may repeat the configuration procedure to create any number of data source names to relational Data Source databases or OLAP Metadata Catalog databases.

The procedures that follow provide information on basic configuration. If you are using more advanced options, refer to the online help for each wizard screen for assistance in completing the wizards.

  To use the SQL Server driver to configure a data source name:

  1. Access ODBC Data Source Administrator by following the procedure in Accessing ODBC Data Source Administrator in Windows.

  2. Click Add to open the Create New Data Source dialog box.

  3. In the driver list box of the Create New Data Source dialog box, select the SQL Server driver, and click Finish.

    The Create a New Data Source to SQL Server dialog box is displayed.

  4. In the Name text box, type the data source name that you want to use for this data source connection.

    In the sample application, TBC is the data source name used to connect to the Data Source database called TBC; TBC_MD is the data source name used to connect to the sample OLAP Metadata Catalog database called TBC_MD.

  5. Optional: In the Description text box, type a description that indicates how you use this data source name.

    For example, you might type the following names to describe the My Business database: 

    Customers, products, markets

    You might type the following statement to describe the sample application database:

    Sample relational data source

    You might type the following statement to describe the sample OLAP Metadata Catalog database:

    Sample OLAP Metadata Catalog

  6. In the Server text box, type the address (either the computer name or the numeric IP address) of the computer where the database tables are stored.

  7. Click Next.

    The second wizard screen is displayed.

  8. Select the appropriate option button for the method to use for verifying login IDs:

    • With Window NT authentication using the network login ID.

    • With SQL Server authentication using a login ID and password entered by the user.

  9. Optional: If you are using a network library other than TCP/IP (the default) to connect to the database server, perform the following steps:

    1. Click the Client Configuration button.

    2. In the Network libraries list, select the appropriate option button for the library that you are using to connect to the database server computer, and click OK.

      You are returned to the second wizard screen.

  10. Optional: Select the Connect to SQL Server to obtain default settings for the additional configuration check box.

    When this check box is selected, the driver obtains default settings from Microsoft SQL Server that it uses to complete additional setup screens in the wizard.

    When this check box is clear, the driver uses standard defaults to complete the additional setup screens in the wizard.

  11. Click Next.

    The third wizard screen is displayed.

  12. Select the Change the default database to check box and then type or select the name of the database for which you want to create this data source name.

    For example, in the sample application, TBC is the name of the Data Source database; TBC_MD is the name of the OLAP Metadata Catalog database.

  13. Click Next.

    The fourth wizard screen is displayed.

  14. Make any entries appropriate to your system configuration and click Finish.

  15. Repeat Step 2 through Step 14 to configure a data source name for an OLAP Metadata Catalog.

  16. When you have completed configuring all needed data sources, click OK to close the ODBC Data Source Administrator dialog box.