---
title: "Database Connectivity Requirements"
slug: "database-connectivity-requirements"
updated: 2025-01-20T14:13:30Z
published: 2025-01-20T14:13:30Z
canonical: "knowledge.curiositysoftware.ie/database-connectivity-requirements"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.curiositysoftware.ie/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Connectivity Requirements

This article outlines the connectivity requirements for establishing a connection between databases and the Curiosity Platform in the Windows environment.

## **1 - Pre-Requisites Verification**

Before attempting a connection, ensure that the following pre-requisites are in place:

### **1.1**Port Configuration

- **Port 8091** (configurable): Ensure that this port is open for inbound communication, both at the network level and within the Windows Firewall.
- **Outbound Ports**: Ensure that outbound communication is allowed (both at the network level and within the Windows Firewall) to any external applications that the VIP needs to connect to (e.g., databases).
- **Optional - Ports 8081–8085**: Open these ports for inbound communication, both at the network level and within the Windows Firewall. This is only necessary if additional VIP servers are being utilized.

### **1.2**Java Configuration

- Open **Windows PowerShell**.
- Run the following command: `java -version`
  - If Java is installed and in the Path, you should see a message with the Java version:

```plaintext
java version "1.8.0_281"
Java(TM) SE Runtime Environment (build 1.8.0_281-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.281-b09, mixed mode)
```
  - If Java is not installed, or not in the Path, you will see an error message:

```plaintext
'java' is not recognized as an internal or external command, operable program or batch file.
```
- If Java isn't installed, download it from the [Oracle Java Downloads](https://www.oracle.com/java/technologies/javase-downloads.html) page.

## **2 - Connectivity Verification via PowerShell**

### **2.1**Verifying Access on Windows Machines

- Open **Windows PowerShell**.
- Run the following command: `tnc -p <port_number> <hostname>`
  - Replace `<port_number>` with the relevant port and `<hostname>` with the target server's hostname.
- **Success**: If the command executes successfully, you can proceed with connecting the database to the Curiosity Platform.
- **Failure**: If the command fails, proceed with the troubleshooting steps below:
  - **Hostname Resolution**: If the command returns a hostname successfully, the issue is likely related to the port configuration. Continue to **Section 2.2 - Firewall Troubleshooting**.
  - If the command does not return the hostname, this may indicate a DNS or network issue.

### **2.2**Troubleshooting Firewall Configuration

If the command in Section 2.1 fails, follow these steps to diagnose and resolve potential firewall issues:

- Type **"Firewall"** in the Windows start menu and open **Windows Defender Firewall with Advanced Security**.
- In the left pane, select **Inbound Rules**, then click on **New Rule**.
- Choose **Port**, then specify the port number used in your connection.
- Select **Allow the connection**.
- Ensure all connection profiles (Domain, Private, Public) are selected.
- Click **Finish** to save the rule.
- Retest the connection in PowerShell by running the same `tnc` command as in Section 2.1.
  - **Success**: If the command succeeds, the firewall issue has been resolved.
  - **Failure**: If the command still fails, it suggests that the issue is related to networking.

### Need Assistance?

If you continue to experience issues or need further assistance with connecting your database to the Curiosity Platform, please contact your Curiosity representative.