SAP Business One Login Error -1102

Posted on 2012-08-17
Last Modified: 2012-08-18
A few months ago I installed SAP Business One on a SQL Server 2008 R2 Evaluation Version. The company hadn't decided which version of SQL to purchase, so it stayed that way for five months. Today I had to upgrade the version to Express since the decision still hasn't been made. The conversion went fine, the databases mounted, and I can connect from the SAP client installed on the server itself. However, the client machines in the network now cannot connect. They throw the -1102 error. Multiple forums on this error point to the firewall, or SQL Native Client.

Here is what I have tried:

1. Uninstall and Reinstall Native Client.
2. Uninstall and Reinstall SAP.
3. The firewall at the server is disabled.
4. SAP has an exception created in the Windows firewall at the client.

Can anyone help with this? Racking my brain...
Question by:riley71
    1 Comment

    Accepted Solution

    After closer inspection, it appears I neglected to enable tcp protocol in network configuration on the Server configuration page of SQL Express. After enabling the protocol, and entering port 1433 on all the server's adapters, it is happy now.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now