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...