Skip to main content
Business Central forum
Answered

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

editSubscribe (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
    ManishS 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
    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 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
    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.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans