Skip to Content
author's profile photo Former Member
Former Member

Error Msg: Connection to the database is lost;(ODBC-1102) [msg 131-183]

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

I don't know what to do more!


I appreciate any help !


Thanks,


Otavio Faccioli

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Posted on Sep 02, 2015 at 04:48 PM

    Do u think the server network card/connection has problem?

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 04, 2015 at 10:49 PM

    Hi,

    Please check below threads:-

    SAP login error | SCN

    Cannot connect to licence server | SCN

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2015 at 11:18 AM

    Did you get any solution for this error? I am facing exactly the same issue at one of my client. 😔

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2015 at 12:25 PM

    Hi Otavio,

    Please try by restarting all the SAP Services on server machine and then start your client machine as "Run As Administration". If this works then ok.

    otherwise, go to run command, enter the server IP or Name with prefix as \\ , if you get the access to server by this method then it shows that server client connectivity is working,

    Regards,

    Bhushan Verma

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2015 at 01:37 PM

    Hi,

    Thank you for your response. My issue is resolved now.

    I used this:

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

    2) Previously, I had configured server with its name but I remove it and configured it 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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 30 at 12:03 PM

    Hi all,

    I have search for all possible solutions but there is nothing helpful. So let me share with you my solution.

    I suppose this error occurs when SAP is installed using the instance name instead of the IP address.

    1- Try to ping this server name.(normally the workstation should be able to ping the IP and Server name).

    2- Check the 1433 and 1434 ports in the firewall if they are allowed.

    I hope it works someday for someone.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2015 at 12:21 PM
    -1

    Hi Otavio,

    The error 1102 can indicate that the database is not available on

    the server or you are trying to connect to a database that does not

    exist.

    Sometimes the database will still be displayed in the login screen, so press the refresh button to see which database the client can access, and then try to login again.

    Also it is recommended to use the server IP address instead of the domain name if this issue happens.

    In SAP Business One 8.8,you need to define a new login in the License Manager->Settings->Configure Security with the server IP.

    If no databases are visible then do the following:

    1. On the Microsoft SQL server make sure that the database you want to log into is available on the server and that it is not detached, suspended or offline.

    2. Reboot your server and then connect to SAP Business one, and check whether you are able to reproduce this issue or not.

    3. If the issue continues:

    a. Take a backup of the SBO-COMMON database

    b. Delete the SBO-COMMON database

    c. Run the 'UpgraderCommon' file from your current patch level installed in the system.

    This will create a new SBO-COMMON database.

    d) Start SAP Business One.

    e) At Logon, click on "Refresh" to retrieve the company list

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.