SAP DI-API Error "-111 - Unable to access SBO-Common database"

New to B1 Usability Package? Check this 5-minute overview for easy SAP Business One Automation, Reporting, Screen Customization, and more!

[NB: Error code "-119" is also related to this error]

What is the reason for this error and how to fix it?

There can be multiple reasons for this Error

Possible Reason	How to Solve
Wrong DB Type selected When defining the Server connection you are also defining the Database Type (Example MSSQL2014, MSSQL2106, or HANA). If you chose the wrong type or you have after setup upgrade SQL server you will get this error	Re-run the server component and check that the Database Type matches the real database
MSSQL Port not opened in Firewall In order to connect to MSSQL Server DI-AP, I need to have access to it in the Firewall	Please on the SQL server open Firewall Inbound Port 1433 (Default SQL Server Port) [Boyum cannot help with firewall related issues beyond this text]
Domain name not included in the sap username	Please include the domain name in your SAP username if relevant. So instead of using "SapUser", use "YourDomain\SapUser"
DNS cannot resolve the server IP-address	Check with Windows command prompt command nslookup that the server name can be resolved into an IP-address

Video on how to fix this