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)
or
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
