Differences

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

--- cobi.wms:installation_guides [2023/08/10 14:30] – tkammer
+++ cobi.wms:installation_guides [2025/02/19 14:29] (current) – thuth
@@ Line 74: / 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.