Cloud Migration Replication fails with "401 - Client request has not been completed"
BEYONDIT GmbH
Beyond Your Galaxy of Productivity – Redefining ERP Solutions with Vision and Innovation.
If you get the following error by using a delegated admin user on the customers tenant:
"Client request has not been completed because it lacks valid authentication credentials for the requested endpoint(url)."
You should read this post.
What's happening? Read the general process or phases you go through to migrate data from on-premises to online here:
I've been using?IntegrationRuntime_5.41.8909.1
Local credentials on SQL are valid and tested. SQL Connection String is also fine!
This is how you connection string should look like:
Server=<server>;Initial Catalog=<database>;User Id=<user>;Password=<pw>;
The user should be a sql server user. It's recommended to use the sa user or you create your own.
You can check it on your sql server like this using powershell:
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = "Server=<server>;Initial Catalog=<database>;User Id=<user>;Password=<pw>;"
$connection.Open();
$connection.Close();
Need help on troubleshooting?
Solution:
It does not work with an delegated admin account - even if that account got granted consent for cloud migration through page 40027.
I had to create a user on the customers tenant and assign a full bc user license - in that case a business central premium license.
It worked like a charm after repeating the cloud migration and using the new user.