Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Cloud Migration Setup ...
Small and medium business | Business Central, N...
Answered

Cloud Migration Setup error Invoking endpoint failed with HttpStatusCode - 401 : Unauthorized

(1) ShareShare
ReportReport
Posted on by Community member 18
Hi,
 
I am getting an error I've never seen before while trying to migrate BC OnPrem 23.1 to BC Online 23.5.
I did this migration with these exact OnPrem and Online versions for a different database last month and did not get this error message.
I am using the same SQL connection string I always use (I just edit the database name).
SQL user I use for the connection is sysadmin and db owner.
 
 
Any ideas?
 
Thanks,
Kevin
 
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    Cloud Migration Setup error Invoking endpoint failed with HttpStatusCode - 401 : Unauthorized
    Hi Kevin,
     
    Make sure that user you are using in your connection string have db owner permission in SQL database.
     
    You can review your steps with this video - https://youtu.be/6WrbjeFdzwA
     
    Regards,
    Saurav Dhyani
  • Verified answer
    Community member Profile Picture
    Community member 18 on at
    Cloud Migration Setup error Invoking endpoint failed with HttpStatusCode - 401 : Unauthorized
    This error can occur in the setup phase and in the migration phase.
    Make sure that the user that is consenting to cloud migration has a Business Central license and has super permissions.
     
    In my case the user that consented to the cloud migration only had internal admin permissions and did not have a Business Central license on the user.
    This seems to be a bug, a user without a Business Central license and super permissions should'nt be able to give consent to cloud migrations.
    ______
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans