Connection to server failed : X3 engine error: TCP Provider: The wait operation timed out. : ini_com:Variable dimension:!(2) (Microsoft ODBC)

SOLVED

Hi,

Version: X3 v12p33

Microsoft SQL Server: 2022 Standard

Full error message from Sage X3: Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out. : ini_com:Variable dimension:!(2)

Context:

IT are doing networking works and changed the private IP.

As such, SQL Server was restarted.

I have adjusted the Database Server firewall to account for new private IP whitelisting for Application Server access to Database Server.

The port number (assume 46723) originally used by Sage X3 for SQL Server was changed after a restart because of dynamic port and static port was not set.

I have now set the static port (assume 51433).

I opened Sage X3 Console and ran the Configure Application.

However, I still have this error.

Top Replies