Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / SQL Error in database ...
Small and medium business | Business Central, N...
Answered

SQL Error in database conversion to the new platform from 19 to 20

(0) ShareShare
ReportReport
Posted on by ManishS 80

We are upgrading On-Prem BC version 19 to 20, we are following steps mentioned in https://docs.microsoft.com/en-gb/dynamics365/business-central/dev-itpro/upgrade/upgrading-cumulative-update-v20

When we start the database conversion as below, we are getting SQL error.

PS C:\Windows\system32> Invoke-NAVApplicationDatabaseConversion -DatabaseServer ./NAVDEMO -DatabaseName "Demo BC 19 36700"

./NAVDEMO
If you convert the database 'Demo BC 19 36700' on the './NAVDEMO' server, you will no longer be able to open it with older versions of Dynamics 365 Business Central.

We strongly recommended that you make a database or transaction log backup in SQL Server before the conversion.

Note that the conversion removes any modifications that you have made to system tables.

Do you want to continue?
[Y] Yes [N] No [S] Suspend [?] Help (default is "Y"): y


Invoke-NAVApplicationDatabaseConversion : Cannot establish a connection to the SQL Server/Database.
This could be due to one of the following reasons:
* SQL Server is not started.
* The database does not exist.
* Proper permissions have not been given to the NAV Server Account.
Try again later or contact your system administrator.
At line:1 char:1
+ Invoke-NAVApplicationDatabaseConversion -DatabaseServer ./NAVDEMO -Da ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (0:Int32) [Invoke-NAVApplicationDatabaseConversion], NavCSideException
+ FullyQualifiedErrorId : ./NAVDEMO,Microsoft.Dynamics.Nav.Management.Cmdlets.InvokeNAVApplicationDatabaseConversion

  • ManishS Profile Picture
    ManishS 80 on at
    RE: SQL Error in database conversion to the new platform from 19 to 20

    Hey Marco,

    Thanks, such a silly mistake didn't noticed.

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: SQL Error in database conversion to the new platform from 19 to 20

    Hello,

    I believe the SQL Server format should be like this sqlservername\bcdemo. I see you are using / instead of \. Then it cannot reach it.

    Hope this helps.

    Thanks.

  • ManishS Profile Picture
    ManishS 80 on at
    RE: SQL Error in database conversion to the new platform from 19 to 20

    Invoke-NAVApplicationDatabaseConversion : Cannot establish a connection to the SQL Server/Database.

    This could be due to one of the following reasons:

    * SQL Server is not started.

    * The database does not exist.

    * Proper permissions have not been given to the NAV Server Account.

    Try again later or contact your system administrator.

    At line:1 char:1

    + Invoke-NAVApplicationDatabaseConversion -DatabaseServer DESKTOP-8VS6B ...

    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

       + CategoryInfo          : NotSpecified: (0:Int32) [Invoke-NAVApplicationDatabaseConversion], NavCSideException

       + FullyQualifiedErrorId : DESKTOP-8VS6BEA/NAVDEMO,Microsoft.Dynamics.Nav.Management.Cmdlets.InvokeNAVApplicationDa

      tabaseConversion

    Still same error.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: SQL Error in database conversion to the new platform from 19 to 20

    Hello,

    I would change the SQL server to match the actual SQL server name (instead of the .\).

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,140 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,895 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans