Specifying the database details - syncsort_capacity_management - 12.60

Syncsort™ Capacity Management Installation Guide
Product type
Software
Portfolio
Integrate
Product family
Syncsort™ Software
Product
Syncsort™ Capacity Management
Version
12.60
Language
English
Product name
Syncsort™ Capacity Management
Title
Syncsort™ Capacity Management Installation Guide
Copyright
2024
First publish date
1985
Last edition
2024-07-17
Last publish date
2024-07-17T13:15:33.732951

Now specify the SQL Server machine and database that this Control Center will use.

It is likely that the Capacity Database has not yet been created, but it must  be specified at this point. The details entered here can be changed later but it is simpler to be able to just remember what you entered. If necessary, write it down for future reference.
Figure 1. Panel 6-5: Syncsort™ Capacity Management Installer – specifying the SQL database for Control Center

Within this phase, it will be necessary to supply the SQL Server instance and the name of the Capacity Data­base that the Control Center will work with.

Note:  The Capacity Database details must be specified at this point, even if it has not yet been created. It can be changed later, using regedit, but it is recommended to specify it as part of the install process.

  • The computer name running SQL Server and, optionally, the SQL Server instance name, separated by a \ character. For example, v-srvr-sql or sqlfarm1\capplanning.

  • If the backslash and the instance name after the SQL Server computer name are omitted then Control Center will attempt to connect to the default instance on that computer.

  • For a non-default instance name, the SQL Browser service must be running on this machine.

  • If your environment requires the use of an explicit port number then after the SQL Server machine name add a comma and the port number to use. For example: v-srvr-sql,5333

  • Do not put both an instance name and a port number. For example, this is wrong: scm12\capac­ity,31433. It will cause Control Center to be unable to find the database and will fail to run.

  • If installing Control Center on the same computer as the SQL Server instance, then you can either enter its name or you can specify one of three standard SQL Server “short cuts” for “my machine”:

    • .  just a “dot” or “period”

    • (local)   exactly as written, include the parentheses

    • 127.0.0.1   the universal IP v4 address of “me”

  • Use the backslash character and add the instance name if this local machine’s SQL Server instance is not the default instance

    For example: (local)\QA
  • Add a specific the port number if not the desired default of 1433.
    For example: 127.0.0.1,20774

Refer to your SQL Server administrator for assistance if necessary.

When all information is entered correctly, then click Next.