How Do I Access the Default Database from My System?

Each trial tenant for AgilePoint NX has a SQL Server database you can use to store and retrieve data for testing and evaluation.

To access this trial database with Microsoft SQL Server Management Studio, do the procedure in this topic.

Video: Configure Access Token for Trial SQL Server Database

Prerequisites

  • An AgilePoint NX trial account.
  • To get the connection string for your trial database, go to Settings > Tenant Settings > Custom Databases > Database Connection String.

    Example:

    server=10.1.21.115;database=ADMIN_7F2D404AB8F5403FB3046705487129C3_CUSTOM_DB_EVALUATION; uid=TrialUser;password=s$8B9E!d-zA3

    10.1.21.115 - This is an internal IP address, and it is used to connect to a trial database from within AgilePoint.

  • To get the database server public IP address for your trial database, go to AgilePoint NX Portal > Settings > Tenant Settings > Custom Databases > Database Server Public IP.

    Example:

    52.201.231.175 - This IP address is used to connect to a trail database from outside AgilePoint NX, such as Microsoft SQL Server Management Studio or a different SQL server connection client. This IP address shows in the Database Server Public IP field.

  • Enter the IP addresses of the systems in the AgilePoint NX Portal > Settings > Tenant Settings > Custom Databases > Allowed IP Addresses field. The IP addresses you enter, only those IP addresses can access the trial database.

How to Start

  1. ‚ÄčOpen Microsoft SQL Server Management Studio.

Procedure

  1. On the Microsoft SQL Server screen, in the Server name field, enter the value of Database Server Public IP field.

    For the example Database Server Public IP:

    52.201.231.175

    Enter:

    52.201.231.175

  2. In the Authentication list, select SQL Server Authentication.
  3. In the Login field, enter the value of the uid from the trial database connection string.

    For the example connection string:

    server=10.1.21.115;database=ADMIN_7F2D404AB8F5403FB3046705487129C3_CUSTOM_DB_EVALUATION; uid=TrialUser;password=s$8B9E!d-zA3

    Enter:

    TrialUser

    .
  4. In the Password field, enter the value of the password from the trial database connection string.

    For the example connection string:

    server=10.1.21.115;database=ADMIN_7F2D404AB8F5403FB3046705487129C3_CUSTOM_DB_EVALUATION; uid=TrialUser;password=s$8B9E!d-zA3

    Enter:

    s$8B9E!d-zA3

    .
  5. Click Connect.