'Processmaker SQL Server connection refused

I'm trying to create a connection to a SQL Server database in processmaker. It uses mssql_connect in order to make connection.

$link = @mssql_connect( $this->ip . $str_port, $this->db_user, $this->db_passwd );

But the problem is: $link is false (that means connection failed).

I tried to debug using echo mssql_get_last_message() and it printed Login failed for user 'myuser'.

I made sure user/password are correct and there is no mismatch, even connected to database using management studio successfully.

Another but: I checked SQL Server logs and found this:

Login failed for user 'myuser'. Reason: Infrastructure error occurred. Check for previous errors

The previous error is:

Error: 18456, Severity: 14, State: 1

which not helping.

Mind blowing... any help would be appreciated... I don't get why Infrastructure error occurred happens... the SQL Server version is 2017 and SQL authentication is set to both SQL + Windows authentication methods

SQL authentication option



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source