Hi everyone. I am trying to test Fabric, using a SQL server running locally. The attached pics have my host info, and in the other pic I need to know what to input in the fields in red. I appreciate any help. Tks in advance

HCL Volt MX Volt MX Forum
1
This thread was migrated from an old forum. It may contain information that are no longer valid. For further assistance, please post a new question or open a support ticket from the Customer Support portal.

**Image removed for security reasons****Image removed for security reasons**

2

Hi,

These are the fields helps in connecting to the database. Below are samples for MSSQL

  1. Driver Class = com.microsoft.sqlserver.jdbc.SQLServerDriver

2. JDBC URL = jdbc:sqlserver://<IP>:<port>;databaseName=<DB name>

3. Username = <username to connect to database>

4. Password = <password to connect to database>

These are mandatory. Hope this helps.

Thanks,

3

Hi,

If the database is MYSQL

Database Driver Class: com.mysql.jdbc.Driver

Database Connection URL: jdbc:mysql://localhost:3306/testdb

If the databse is SQL Server:

Database Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Database Connection URL: jdbc:sqlserver://localhost:1433;databaseName=test

Syntax for connection URL (SQL Server) :

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

Based on the screenshot details, it seems MySQL is db, please check and make the changes accordingly.

4

Thank you. Very helpful!!!!

5

Thank you!

6

Hi, glad you could get some help. Were you able to reach a resolution? If yes, please click [Select as Best] under the response that helped you the most. This will close out the ticket.

7

Now I am getting this error msg: Failed to do test connection. Not authorized to access private endpoint 127.0.0.1 [fc0df503-5826-4a32-b062-acaf30c642ac]

see my server info below:

any help is very much appreciated.

@Steven Scotth​ @Dvn Cvmpxell​ d**Image removed for security reasons**

8

I think it is unable to reach database. Please give ipaddress of the machine where mysql is installed instead of localhost or 127.0.0.1

And also verify if you are able to ping to the database host(IP) from the MF server installed machine.