Dynamics Community Forum Thread Details

Upgrade BC from v16 to 20

Hello,

I'm doing upgrade for DB from BC v16 to BC v20.

I'm using Azure to manage SQL and BC on Prem.

Do you have any idea how to execute Invoke-NAVApplicationDatabaseConversion with azure user, I don't have local windows user on SQL.

This error I get when I run this script:

Invoke-NAVApplicationDatabaseConversion -DatabaseServer 'sqlmondial01.database.windows.net' -DatabaseName 'BC-PROD' -ApplicationDatabaseCredentials (Get-Credential)

Invoke-NAVApplicationDatabaseConversion -DatabaseServer 'sqlmondial01.database.windows.net' -DatabaseName 'BC-PROD'

Error:

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.

This function give by Microsoft, is there any way to put user like aaaa@domain.com with the password to run the script.

Invoke-NAVApplicationDatabaseConversion [-DatabaseServer <String>] -DatabaseName <String> [-ApplicationDatabaseCredentials <PSCredential>] [-Force] [-WhatIf] [-Confirm] [<CommonParameters>]

Thanks

Quick Links

Leaderboard