Skip to Content
Mar 15, 2021 at 07:37 PM

SAP B1 Service Layer Multiple Database Servers

652 Views Last edit Mar 16, 2021 at 03:48 AM 2 rev

We have 2 SQL Server instances (Server A and Server B)

On server A we have Company_1 on that SQL Server. We also have the Service Layer / Load Balancer installed on that server.

On server B we have Company_2 on that SQL Server. There is no service layer installation.

These servers/companies are both registered on the same SLD.

However, I cannot Login to server B via the service layer.

POSTing to https://server_a:50000/b1s/v2/Login with body

{"CompanyDB": "Company_2", "UserName": "manager", "Password": "password"}

Leads to the error:

{ "error": { "code": 100000027, "message": { "lang": "en-us", "value": "Error while connecting to database server ---Server_A SQL Instance----\n" } } }