Introduction

This Article will helps you to solve the DB connection issue.

Instructions

Steps to Reproduce

1. Create a new project
2. Goto Organization and click host
3. 3.Enter MS SQL Server details (server details and hostname)
4. Check the Custom driver setting and make sure the dependency Jars
5. In the Pre-Install Sequence add the Database connection panel
6. In the Install Sequence add the Run sql script action with any sample sql file
7. Build and run the project.

You can see that the Database connection will fail ( Invalid username and password).

Solution

Click on SQL Server Configuration Manager --> SQL Server Network Configuration--> Protocols for <Name>-->Right click on Properties-->
Click on Tab "Flags"--> Force Encryption--> No other possibilities,

1. Disable the firewall
2. Pre-enabling the port( if still issue try with the default port)
3. Check the connectivity between the two machine (database and IA)
4. Check with hostname instead of IP