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
