You can use OpenEdge Management or OpenEdge Explorer to configure the DataServer for MS SQL Server.

Note: This section primarily focuses on how to access OpenEdge Management or OpenEdge Explorer to configure the DataServer for MS SQL Server. It briefly presents a few examples about how to connect the DataServer. However, for more complete connection instructions, see Starting and stopping a broker process from OpenEdge Management/OpenEdge Explorer and connecting a client. For information about OpenEdge Management or OpenEdge Explorer, see the OpenEdge Management or OpenEdge Explorer online help.

To access OpenEdge Management or OpenEdge Explorer in Windows:

  1. Make sure that the AdminService is running.
  2. Start the OpenEdge Management or OpenEdge Explorer. Choose Start > Programs (or All Programs) > Progress > OpenEdge > Management Console or OpenEdge Explorer.
  3. Connect to localhost and log in.
  4. From the console's left pane, select the MSS DataServer folder and double-click. The list of existing DataServer brokers for MS SQL Server appears in the right pane.
  5. Select the DataServer instance whose properties you want to create or edit, and click Configuration so that the DataServer properties appear.
  6. Click Edit.
    Note: The DataServer for MS SQL Server installation provides one predefined DataServer Broker (mssbroker1) and one predefined NameServer (NS1). (The NameServer is located in the NameServer folder.) Each broker is referred to as an instance. See the OpenEdge Management or OpenEdge Explorer online help for more information. You can use these predefined components as a starting point for creating and configuring additional DataServer Brokers, and, if needed, NameServers. (See OpenEdge Getting Started: Installation and Configuration for information about the NameServer's role in a configuration.)
  7. Configure the DataServer broker by setting the Broker properties, Server properties and Environment Variables. For details on these settings, see the OpenEdge Management or OpenEdge Explorer online help.

    Proceed to 7.a to use the DataServer for MS SQL Server broker instance with a controlling NameServer (as provided by a default Data Service). Otherwise, proceed to 7.b to use the broker instances or without the NameServer (using the -DirectConnect parameter option):

    1. To use the controlling NameServer to manage your broker instances, use the Data Service (This is the default and recommended option. For syntax and examples, see Connecting to a MS SQL Server DataServer broker using the NameServer.) As a result, the DataServer client's initial connection is to the NameServer.
    2. To connect the DataServer directly to the broker instance, do one of the following:

      • Set the -DataService value to none in the connection parameters of your schema holder.

        If you plan to always use a -DataService value of none, remove the controlling NameServer from your broker instance definition.

      • Add the -DirectConnect parameter to override your -DataService parameter.

See Starting and stopping a broker process from OpenEdge Management/OpenEdge Explorer and connecting a client for more information about connecting the DataServer to the NameServer and the broker.