BC14 to Bc23 Upgrade Error

(5) Share

Report

Posted on by Sarath

Hello every one,

I am new to upgrade process and this is my first upgrade process, i am doing the upgrade from BC14 to BC23 at the time of sync my bc14basetables only it throwed me an error connection to sqlserver is no longer available can anyone tell me what i have to do now.., i am using the BC14 and BC23 are w1 versions only, i tried with force also but the error is same.....

Categories:

Dynamics 365 Business Central migration

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Andrés Arias 5,166 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello

I hope the following information can help:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-to-business-central-on-premises

Would you recommend to check permissions on SQL Server, supported versions, correct migration of objects?

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

adding more details

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-technical-upgrade-v14-v23

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
"A connection to SQL server is no longer usable."
suggests that the sync operation failed due to a SQL Server connectivity issue during your BC14 to BC23 upgrade.
Here's a brief checklist to resolve it:

Verify SQL Server Status:

Ensure the SQL Server instance hosting your BC databases is running.

You can check this via SQL Server Management Studio (SSMS) or Services.msc.

Check SQL Connection Strings:

Confirm that the BC230 server instance is correctly configured to connect to the SQL Server.

Validate the DatabaseName and DatabaseServer settings in CustomSettings.config.

Network & Firewall:

Make sure there are no network issues or firewall rules blocking SQL Server ports (default is 1433).

Try pinging the SQL Server from the machine running the sync.

SQL Server Authentication:

Ensure the service account running BC230 has access to the database.

Check for any login failures in SQL Server logs.

Restart Services:

Restart both SQL Server and BC230 instances to refresh connections.

Retry Sync:

After confirming the above, rerun the Sync-NAVApp commands.

Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Verified answer

Sarath 92 on at

Like (2)

Report
Copy link

Link copied!

Thank you all for your help, that error caused due to the storage problem with there DB fixed now after increase in the Storage.

Thanks & Regards,

Sarath

Was this reply helpful? Yes No