When using Microsoft SQL Server

(1) Target database

The database that can be used as a repository database is as follows:

  • Microsoft SQL Server

(2) Necessary information for a repository database

When you use the database described in the target database as a repository database, the following information is necessary:

  • Host name or IP address for the environment in which the target database is installed

  • Number of the port providing the service (default value: 1433)

  • Database name

  • Path to the supported JDBC driver

    For details on supported JDBC drivers, refer to HULFT Script system requirements on our website at the following URL:

    URL: http://www.hulft.com/

(3) User settings

Follow the procedure below to configure the settings for the database, and confirm that external connections can be made.

1. Add new users to the database.

2. Set the db_owner role to the user you added in step 1. .

Use the user you added in step 1. to perform the procedure in (4) Repository database settings.

Note

  • For the database, it is necessary to set a case-insensitive collation order.

  • Connections cannot be made using Integrated Windows Authentication.

(4) Repository database settings

After installing HULFT Script, configure the settings for the repository database in Control Panel - Repository DB Management in HULFT Script Studio.

The details of the settings for repository database management are shown below.

Table B.5 Settings for repository database management (Microsoft SQL Server)

Field Name

Setting Description

DBMS

SQL Server

JDBC Driver Path

Path to the supported JDBC driver confirmed in (2) Necessary information for a repository database

URL

URL of the repository database

Example: jdbc:sqlserver://<host_name>:<port_number>;DatabaseName=<database_name>

User

User added to the database in (3) User settings

Password

Password used in the settings for the user