"Data Source Test Failed" CA Strong Installation

[Adarian Dunmeyer]

I am attempting to install the CA Strong into my 2016 instance. I have JDK set up, my server created at localhost\SQLSERVER1, a database named SQLDB1, and a user named sqladmin1. As i'm doing the data source test in CA Strong I received the error message:

"Checking Primary DB Connectivity..."

"Testing database connectivity...failed"

"Backup DB not configured"

"Data Source Test Failed"

 

Can someone help troubleshoot this?

[Awijit Singh]

Hi Adrian, Try giving the actual HOSTNAME or IP address in of the machine where your sql server is installed which is your local machine and see if that helps. Give this in the "server" field

 

Thanks
Awijit 

[Adarian Dunmeyer]

Thank you Awijit, unfortunately I still receive the same error, in both cases. Any other ideas?

[Awijit Singh]

Hi Adarian, that is weird. Is a database named SQLDB1 already created ?

[Adarian Dunmeyer]

Yes Awijit, this is how I have it set in Server Management Studio. I've tried changing the server name to what is listed and it doesn't work either.

[Adarian Dunmeyer]

Thank you for the help, I figured out the issue was that it was because I was using SQL Server 2014 Express; my server was not listening to Port 1433, so I went to enable TCP/IP in Server Configuration Manager, then entered 1433 in the IPALL of the IP Addresses.

[Vittoria Lorusso]

Hi, we faced in the same error, I can ping the oracle db and I can reach the db on port 1521 with a telnet. How can I see the log? I'm in the installation phase is there any location where I can find some installing logs?

We have Oracle RAC 12.2

 

The error is the same

"Testing database connectivity...failed"

"Backup DB not configured"

"Data Source Test Failed"

Thanks

Vittoria

[Awijit Singh]

The logs will be generated after installation. Are you able to connect to this host and port from this machine using terminal or cmd ?

Can you check if that port is open ?

Is there any firewall blocking that port ?