To install the service module on the SQL-server by clicking on the Setup.exe file in the B1 InterCompany-install package and follow the install instructions.
During the installation the service will attempt to find database login information from other Boyum add-ons, if it finds one that is able to connect to the database then it will save that connection string to the B1Intercompany.Service.exe.config file in the directory where the service was installed.
If it cannot find a working connection string, then you will be prompted to input connection information to the SQL server on which the databases are running.
Use the ‘’Test’’ button to verify that the inserted data is correct, and a connection can be established.
IMPORTANT: Please note that value in the server must be the same as the License Server in the Database Configuration form; Either IP or host name both places, not different values.
IMPORTANT: It is only possible to have one InterCompany setup per SQL-Server. Never run test- and live-environment of B1 InterCompany on same SQL-server.
IMPORTANT: For HANA if the SAP B1 client server is written with database name before the database server, then it also needs the database name before the database server on the database configuration form
So if SAP B1 client says that the current server is databaseName@someServer:port, then you need to write the exact same thing in the database server field in the above screenshot).
If you forget to add the database name from the database server, then testing may give a positive result as it will be able to connect to the database, but SAP B1 may give an "Error during SBO user authentication" error due to the missing database name.
NOTE: The connection string will be in plain text until the first time the service successfully connects to the database server, after which the connection string will be encrypted.
TROUBLESHOOTING: If you get an error message from the service during usage that mentions “Keyword not supported: 'driver'” then try going to the B1Intercompany.Service.exe.config file in the folder where the service is installed and set the value of the appSetting “IsIcDatabaseHana” to true and retry. The database configuration form should set the appSetting automatically when HANA is chosen as database type.