Configuring SQL Server for Use with Sterling Gentran:Server

Before installing Sterling Gentran:Server®, you must create the database that contains the Sterling Gentran:Server tables. These database tables are built during the Sterling Gentran:Server installation.
Notes:
  • This procedure uses wizards within SQL Management Studio. If you are an experienced SQL user, you may decide to configure SQL directly.
  • The SQL server configuration is flexible and provides numerous options. We recommend that you research the configuration capabilities of SQL to determine which settings are optimal for your installation, based on the volume of data you expect.
  • The steps you need to perform are specific to the version of SQL server. If you are using another version, the tasks may vary.

Use this procedure to configure SQL server and create your database.

  1. From the Start menu, select Programs > SQL Management Studio.

    The first time you execute the SQL Server Enterprise Manager, you are prompted to register the SQL server.

  2. Select Microsoft SQL Server.
  3. Select your server name and expand.
  4. Right-click on Databases and select new database.
  5. Type GentranDatabase as the name of the database.
    Note: Sterling Gentran:Server is case-sensitive, so be sure to type the database name in the proper case.
  6. Click OK.