Applications: Configuring a Microsoft SQL Server

Database Selection

1. Log in to your Next Generation Hardware Appliance.

2. Open the Applications page.

3. In the section Application Settings the Database Selection tiles are displayed.

4. Click the tile Microsoft SQL Server.

Microsoft SQL Server Database Configuration

After you select your external database, fill in the required information.

The following configuration options are displayed:

Database Host

• Database IP Address / FQDN (required)
  Enter the IP address or the FQDN (Fully Qualified Domain Name) of the external Microsoft SQL Database.

• Database Port:
  The default Port 1433 is displayed, if applicable adjust the port used by the database host.

• Database Instance:
  Enter the name of your database instance.

• Database Name:
  Enter the name of your database.

Database Authentication

• Database Username (required):
  Enter the username used to connect to the database.

• Database Password (required):
  Enter the password used to connect to the database.
  

Additional Settings

• If the configuration of the Java Database Connectivity JDBC connector you require cannot be achieved using the Connector Properties -Form element supplied,
  you can override the JDBC connection string directly by using the JDBC Connection String Override option.
  This is helpful if you want to use Microsoft SQL Server's internal load balancing, for example.
  Please note that any kind of confidential information contained in the JDBC Connection String Override can be included in the appliance log.se are passed to the JDBC connector via the connection URL. These properties give you better control over the database connection.

For details on the corresponding commands, please consult your Microsoft SQL Server documentation.

Connector Properties:

• Name:
  Enter a property name

• Value:
  Enter a value

• Confirm your entries by clicking Add Property in the column Actions.
  Please do not remove the setting encrypt=false in the second line when configuring Microsoft SQL Server for the first time.
  

Connectivity Check

• With Test Connection you can check, whether the connection to the external database server can be established with the given configuration data.

• In case the connection test fails an Error Message will appear for further information.

• The connection test could fail if you enter incorrect settings like:

  • IP Address, Database Name or

  • Wrong Password.

If the connection test was successful your settings with information like:

• Hostname,

• Server Version and

• Driver Version will be displayed in a table.

You can save the configuration with Save Configuration anytime.