SAP Business One Error: Connection to the Database Is Lost

This article references the system message you encounter when logging in a new SAP Business One database after copying from a production database.

With References to SAP Note:

SAP Note 2825180 PDF File download

SAP Note 3303958 PDF File download

Symptom

The logon fails with the following error messages:

• Connection to the database is lost; contact your system administrator (ODBC -1102)  [Message 131-183] 
• [SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 258 insufficient privilege: Not authorized 'Company Info' (CINF) 

Resolution

You can refresh the database user from the SLD control center by performing the following steps:

1. Log on to the SLD control center.
2. On the DB Instances and Companies tab, select the company for which the logon failed.
3. Click the Refresh Database User button. 
4. The company database user is refreshed and you can try and log on again to SAP Business One. 

If the error still appears , perform the following steps:

MS SQL Environment;

• 1. Logon to SLD Control Center
• 2. Go to DB Instances Tab-> Companies - > Find the Database User for the database which is locked. Make a list. (Database user starts with B1_*********_RW)

• 3. Stop all the Business One related services on the machine. Server Tools, Service Layer etc.
• 4. Close all the SAP Business One Clients.
• 5. Login SQL Server Management Studio > Security - > Users -> Right-Click the user which you want to unlock (point 1 B1_*****-RW) -> Properties
• 6. Check that user is mapped accordingly and appropriate access rights are checked. (i.e. db_owner)