Fail to connect to SQL Server - Three tiers

Business Central/NAV Technical Forum
1

Dear experts

I have a problem of the system.

My System is:

  • 1 sql server

  • 1 NAV Service Server

  • Client

The System worked well, but the IT department change the IP of NAV Service Server. Then i got the problem:

  • Client cannot connect, it shows error :“Cannot connect to SQL Server”, like error of wrong SPNs or delegation setup.

Try to Solve:

  • I try to open RTC from NAV Service Server → It’s ok

  • Try to delete and insert SPNs again, remove delegation and add it again → still don’t solve.

  • Try to create new windows service with another port → cannot connect too.

  • Using Best Practice Analysis → don’t show any errors.

Change IP of server then system die. Please help me to solve it.

Many Thanks