SAP Business One 10.0 FP2208: Connection to the database is lost; contact your system administration

[former_member236882]

Hi expoerts,

I am running SAP Business One 10.0 FP2208 and I encounter system message "Connection to the database is lost; contact your system administration (ODBC-1102)" while trying to login to the database by using server's ip address. I have tried the following:

1. Refresh Database User in SLD
2. Check that user is mapped accordingly and appropriate access rights are checked
3. Add new connection with the IP address of server
4. Switch off the firewall in the server and client
5. Switch off antivirus in both server and client
6. Network connection is there between server and client
7. Server restarted

Kindly assist. It's urgent

[abdelrahmansade]

Hey
It's worked with me by follows:
1. Go to SLD and get the database user of the database.

2. Go to hana studio find this use and activate it.

Thank you
Abdelrahman

[chladek]

The function Refresh Database User should be reachable via command line, this I miss!

[Mabner]

I had to set the sysadmin role for the db user in order for it to work.

[mta1]

After upgrade to FP 2511 i have the same error messages. My solution was to delete and re-add the DB instance in SLD.

[mta1]

In my case the solution was to delete the DB instance in SLD and re-add them.

[mayanksingh1029]

Check 1 -

Login to SLD

Click on DB Instance and select the database and click on refresh database user.

Check 2 -

Copy the Database User against the company database from SLD login.

Log in into SQL/Hana database 

Select on Security-> Login-> Filter as per the database user

Right click on User and select Properties, check for status, it should be enabled.

[Abdul]

Please check is there recent windows upgrade. Please check all the SAP B1 services on server before investigating network

[SonTran]

Hi,

You can refer to the SAP Note 2825180 - Database Connection Is Lost When Logging on to SAP Business One - SAP ONE Support Launchpa...

Hope this helps,

Son Tran

[Neeraj_Jain1]

Hello chongyanyan,

Please refer below SAP thread.

https://answers.sap.com/questions/11861222/error-msg-connection-to-the-database-is-lostodbc-1.html

Regards,

Neeraj Jain