Differences

This shows you the differences between two versions of the page.

--- cobi.wms:installation_guides [2023/06/26 20:38] – [On-premises or private cloud, with Service Layer] tkammer
+++ cobi.wms:installation_guides [2025/02/19 14:29] (current) – thuth
@@ Line 26: / Line 26: @@
 ===== (SBO 9.3 or earlier only) On-premises or private cloud, MS SQL Server =====
+**Warning: The use of Integration Framework with COBI.wms is deprecated and highly discouraged for new installations.  Most new COBI.wms features are only available when using Service Layer.**
 If you have an **on-premises or private cloud** installation of SAP Business One **Version 9.3 or older**, based on Microsoft **SQL Server** then please refer to the following steps.  Note that the **Integration Framework** must be installed already.
@@ Line 31: / Line 33: @@
   - Import the **[[B1i Scenario Package]]**
     - Afterwards, copy the **Trigger** URL as described in the linked page and temporarily save it somewhere
-  - Follow all the steps of the following section (on-prem with Service Layer), with the following differences:
+  - Follow all the steps of the previous section (on-prem with Service Layer), with the following differences:
     - Use the Trigger URL for the ''APIURL'' field of the SAP Business One company connection added to the Management Database
     - Make sure that TCP Port 8080 for Integration Framework is opened on the server
@@ Line 72: / Line 74: @@
   * **[[Print Settings]]**: See here for connecting to ZPL-based label printers.
   * **[[Label Templates]]**: See here for a guide on designing COBI.wms label templates.
+===== FAQ =====
+==== SQL Server Port Issue: ====
+When connecting to the SQL Server, you may encounter issues that are often related to firewall restrictions or SQL Server configuration problems.
+**Explanation:**
+The issue is typically due to one of the following reasons:\\
+  - **Firewall Blockage:** The SQL port (commonly port 1433) might not be open between the COBI.wms device and the SAP Server. \\
+  - **Server Configuration:** The SQL Server might be configured to disallow TCP/IP connections.
+**Steps to Diagnose and Resolve:**
+. **Check Port Accessibility:**
+   - From any Windows client on the same network as the COBI.wms device, open a PowerShell console.
+   - Execute the following command (replace `<SAP_Server_IP>` with the actual IP address of your SAP Server)
+PowerShell:
+     Test-NetConnection <SAP_Server_IP> -Port 1433
+     Expected Output:
+     The PowerShell output should show `TcpTestSucceeded : True`.
+ If it shows **False**, the port is likely blocked by the firewall.
+. **Verify SQL Server Configuration:**
+   - If the port is accessible (i.e., `TcpTestSucceeded` is True) but the connection still fails, the SQL Server might be blocking TCP/IP connections.
+   - On the server running the SAP MSSQL Server, open **SQL Server Configuration Manager**.
+   - Navigate to **SQL Server Network Configuration** → **Protocols for [InstanceName]**
+     (Note: The instance name may correspond to your SAP system, e.g., "SAP").
+   - **Ensure that TCP/IP is enabled.**
+. **Using a Dynamic TCP/IP Port (if necessary):**
+   - If problems persist, consider connecting via the dynamic TCP/IP port:
+     - In **SQL Server Configuration Manager**, double-click on **TCP/IP**.
+     - Go to the **IP Addresses** tab and locate the dynamic port setting.
+     - Enter the dynamic port number in COBI.wms under the "Optional Fields: DB-Portnummer" (DB Port Number).
+     - Make sure the dynamic port is also allowed through the firewall.
+       You can verify this by running the PowerShell command again, substituting port 1433 with the dynamic port number.
+**Customer Confirmation:**
+One customer confirmed that switching to the dynamic port resolved their connection issues.