Set up a data source that uses the Microsoft SQL Server driver

Microsoft Query

Show All Show All

Set up a data source that uses the Microsoft SQL Server driver

  1. If the Create New Data Source dialog box is not displayed, click New on the File menu, click the Databases tab, and then double-click New Data Source. Type a name for the data source in step 1 and select SQL Server in step 2.
  2. In step 3, click Connect.
  3. In the Server box, enter the name of the SQL Server on your network. If you want information about the selections available for Server, click Help.
  4. Click Options, and set any other options required for your database. For information about whether you need to change any of these settings, see the administrator for your database. For information about the option settings, click Help.
  5. Enter your logon ID and password, and then click OK twice.