Error Msg: Connection to the database is lost;(ODBC-1102)

[Former Member]

Dear All,

When i am logging into client system of SAP Business One, i am getting the error as mentioned below

"Connection to the database is lost;contact your system administrator(ODBC-1102) [Message 131-183]"

In the server machine, i am able to login , but in all the client machine i am getting this error.or Internal error(-1102).

I have tried all possible options :

• Switch off the firewall in the server and client
• Switch off antivirus in both server and client
• Network connection is there between server and client
• Sometimes if i Restart TAO NT Naming service , the client system will open ,but again if i re-login same error is shown.

Kindly let me know, if anyone had face same issue  and had resolved it

Thanks&Regards

Darshan Desai

[Former Member · Accepted solution]

Hi,

Try these;

1- Sap Service Manager ->  License Manager -> Settings -> Configure Security -> Logged in to System landscape director (by entering B1 site user password).

2- Add new connection with the IP address of server.

3- And then after refreshing, it showed all the DBs in companies section.

4- After this, SAP started working on all clients machines too.

Regards.

Eray ENGIN

[g_lapierre · Accepted solution]

Hi Eray,

Almost the good answer

1- Sap Service Manager -> License Manager -> Settings -> Configure Security -> Logged in to System landscape director (by entering B1 site user password).

Instead of adding a new connection, delete the actual one and re-create it. (so you can stay with the same installation name)

Thanks

[pralin_01]

The workaround solution to this problem:

1.Refresh the database user from System Landscape directory .

2.Find the database user of running schema from System Landscape directory then Go to hana studio with the SYSTEM user and under user select the database user and activate the user.

Note: If it is because of multiple login attempts failed then increase the login session through security tab in haha studio.....

I resolved my issue with this workaround!!!!

[kevlang]

I was able to resolve this without re-installing anything. I restarted the SQL Server Service, and it seems to have resolved the issue.

[robert_daniels]

For us it was TLS 1.0 being disabled on the server causing this.
Our fix was to uninstall everything SQL on the client PC, restart, then install the latest SSMS from Microsoft.

[Former Member]

Hi,

I had to format the server and freshly install SQL and SAP .Its working,but network connectivity needs to checked before you format.

Regards

Darshan Desai

[Former Member]

Any news? I am having the same problem , and I can't access the notes !

[KennedyT21]

Hi Darshan,

what is the SAP versions...

Rgds

[Former Member]

HI Kennedy,

The SAP version is 9.1 patch level 5

Regards

Darshan Desai

[KennedyT21]

check this note

1440193 - Unable to login to SAP Business One - Error -1102

[kothandaraman_nagarajan]

Hi,

There is SAP note for this error message. Please find from SAP B1 customer portal.

Thanks

[Former Member]

Hi Nagarajan,

Can you please let me know the SAP note number for this error,

Regards

Darshan Desai