SWPM: SSL Security error ConnectionOpen (SECCreateCredentials())

While installing the additional application server using the software provisioning manager (SWPM), below error prompted,

Cannot connect to HOSTNAME
Error(s) returned:
SSL Security error ConnectionOpen (SECCreateCredentials()).
SOLUTION: Check that you specified the correct name for the database server,
that the server is running and you are authorized to log on to it

This error was occurred on Windows operating server and Microsoft SQL Server.

Solution

The resolution was shared in SAP Note 2704496 – SSL Security error while PAS or AAS installation with MS SQL. You can refer as below,

Maintain the hostname and IP address of the server or application or instance in the hosts file.
You should install SQL Server on the database server and the client tools on the application server first.
Ensure SQL Server Native Client is installed on your application server. You’ll need it in order for SAP and SQL Server to communicate with each other. (for SQL 2012, you only need to install SQL Server Native Client at application server)
Location of hosts file: \Windows\System32\drivers\etc\hosts

The SQL Server Native Client and the ODBC drive can be download from the Microsoft website. Please refer to below SAP Notes for further information,