Connection String Builder Window

Creates a connection string to connect AgilePoint Event Services and a database.

Navigation

  1. On the Enterprise Manager Main Page, click Events Service.
  2. On the Event Service page, click Database Insert > Add.
  3. On the Database Insert Configuration window, click Build Connection String.

Field Definitions

Field Name Definition

Data Source

Definition:
Specifies the database server name, where SQL Server has been installed.
Allowed Values:
A valid database server name.
Default Value:
None.
Custom Attributes:
No
Example:
Demo3

Port

Definition:
Specifies the port number to connect to the database server.
Allowed Values:
A valid port number.
Default Value:
None.
Custom Attributes:
No

Integrated Security

Definition:
Determines whether the SSPI integrated security is to be activated.
Allowed Values:
  • Deselected - Specifies not to activate the SSPI integrated security.
  • Selected - Specifies to activate the SSPI integrated security.
Default Value:
Deselected

User ID

Definition:
Specifies the user name for database authentication.
Allowed Values:
A valid user name.
Default Value:
None
Custom Attributes:
No

Password

Definition:
The password for the authentication account.
Allowed Values:
A valid password.
Default Value:
None
Custom Attributes:
No

Retrieve Database

Function:
Retrieves the names of existing databases from the data source.

Database Name

Definition:
Specifies the name of the database you want.
Allowed Values:
The name of your database.

If you select the Enter Database Name check box, the Database Name list becomes unavailable to select a database name. Type a database name in the box.

Default Value:
None

Enter Database Name

Definition:
Specifies that a custom database name is entered in the Database Name field.
Allowed Values:
  • Deselected - Specifies to select a database name from the Database Name list.
  • Selected - Specifies to type a database name in the Database Name field.
Default Value:
Deselected

OK

Function:
Generates the connection string.