Progress
DataServer for
Microsoft SQL Server
Guide


Configuring with ProControl

This section describes how to configure the remote DataServer on the NT host using the ProControl utility. The Progress ProControl utility provides a graphical interface that allows you to manage and configure the DataServer host environment interactively.

If you have not used ProControl before, see the ProControl online help for security issues. For example, depending on whether a drive is configured as FAT, you might need to specify in the NT Services utility the account that users will use to log on.

To configure the DataServer components on the NT host using ProControl, follow these steps:

  1. Access ProControl by double-clicking its icon in the NT Control Panel. The ProControl dialog box opens.
  2. Choose Detail. Tabbed folders appear.
  3. Choose the Options tab and activate the DataServer Page toggle box.
  4. Choose OK and then choose Detail on the ProControl main window. The DataServers tab appears.
  5. Choose the DataServers tab and choose Insert to add an entry for the broker. The General and Environment tabs appear.
  6. Enter the appropriate information in the following fields in the General folder:
    • Identifiers — Provide a unique name to identify the broker. The name must be unique to the host. The identifier can be up to 30 characters long. For example, you might name it mssbroker.
    • Executable Name — Specify the broker executable. By default, the _probrkr.exe executable displays. If you want to use a customized executable that you built using the PROBUILD utility, specify it here.
    • Working Directory — Specify the directory that the broker uses, for example, to create the dataserv.lg file.
    • Service Name — Specify the value for the Service Name (-S) startup parameter. Look in your install-path\system32\drivers\etc\services file for an available service that the broker can use.
    • Network Protoco l— Specify TCP for the Network (-N) startup parameter.
  7. Activate the Auto Start toggle box if you want the broker to start automatically when you boot the host machine. To start the broker automatically, you must also use the NT Services utility to set the Progress ProService utility to start automatically.
  8. Choose the Environment tab in the DataServers folder.
  9. In the Environment tab, set the MSSSRV variable to the DataServer executable that you are using. The default is %DLC%/bin/_msssrv.exe.
  10. Choose OK.
  11. Start the broker by selecting the identifier and choosing Start on the DataServers folder.

Once you have completely set up your environment, you can build the schema holder for your SQL Server™ database. See the "Creating a Schema Holder" section for instructions.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095