Heidenhain codes
HeidenhainServo/AxisIntermediate30-120 minutes

230-022E

HEIDENHAIN 230-022E - No connection to the SQL server

No connection to the SQL server

This TNC7/TNC 640 error indicates an issue with 230-022E. No connection to the SQL server.

Root Cause Summary

HEIDENHAIN alarm 230-022E indicates the TNC control cannot establish communication with the configured SQL database server. This typically occurs due to network connectivity issues, incorrect database configuration parameters, or SQL server service problems.

Safety

  • Refer to Heidenhain service manual
  • Ensure qualified technician performs repairs

Causes and Fixes

  1. 1

    Check physical network connection

    Verify Ethernet cable connection at X116 connector on TNC control and check link LED status on network interface.

    Ensure machine is in safe state before accessing control cabinet

  2. 2

    Test network connectivity

    Access MOD function, select 'System Info' and check network adapter status. Verify IP address assignment and ping SQL server IP if accessible.

    Use MOD > Network Settings to view current IP configuration and adapter status

  3. 3

    Verify network infrastructure

    Check network switch ports, cables, and ensure SQL server is powered on and accessible from other network devices.

DIY Feasiblemedium confidence

Call a technician if:

  • ·Network infrastructure changes required
  • ·SQL server configuration changes needed
  • ·Persistent connection failures after basic troubleshooting

Prevention

  • Configure automatic NTP time synchronization
  • Implement network monitoring for SQL server availability
  • Document and backup database configuration parameters
  • Establish redundant network paths if critical

Common Mistakes

  • Forgetting to check SQL Server Browser service for named instances
  • Not verifying firewall settings after network changes
  • Using incorrect port numbers for custom SQL installations
  • Overlooking time synchronization requirements

Seeing Multiple Alarms?

Seeing another alarm with this one? Enter the code.

Get machine-aware diagnosis

AxisMD logs alarms against your actual machines, tracks patterns, and gives AI context your manual doesn't have.

Start free

Was this guide helpful?

Always verify with your machine manual or a certified technician before performing service procedures.