Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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 6,578

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

Categories:
  • ManishS Profile Picture
    6,578 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
    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
    6,578 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
    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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard > Small and medium business | Business Central, NAV, RMS

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans