• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3452
  • Last Modified:

SAP Business One Login Error -1102

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...
1 Solution
riley71Author Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now