It seems like the app VM cannot access SQL VM. But logins are working, I can assess DB via SQL server management studio with domain user. It is like config DB cannot be accessed. Any ideas? How to troubleshoot?
EDIT: When accessing Central Admin the error is:
EDIT: Troubleshooting Allen_MSFT first link:
No | The Database Server is down.
No | The SQL Server Services are stopped.
No | The Database server is not reachable from the Application server (Firewall Issue / SQL Server Port is closed).
No | The SQL Server license has expired.
? | The SQL Server Service account credentials were changed. (MSSQLSERVER service is made Logon as Local System Account)
No | The App Pool account for web application is locked or disabled.
No | The farm account is locked or disabled.
No | The farm account password is expired.
? | The farm account doesn’t have Allow Logon locally. Logon as Service. (On which service?)
? | The farm account doesn’t have sufficient permission on the database server, configuration database, and content databases. (The farm admin did not existed in SQL DB server security logins. After creating it the error appears (see pic below))
No | The SharePoint Configuration database is in recovery mode and its status is not online.
? | The farm servers are not joined properly. (I cannot join them, got error)