• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3087
  • 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...
0
riley71
Asked:
riley71
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.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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