Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Failed to apply update...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Failed to apply update 10.0.31 on a local dev box 10.0.27

(0) ShareShare
ReportReport
Posted on by Alan Zhou 56

Hi Guys,

I am applying update 10.0.31 on a local dev-box which was created by 10.0.24 VHD and updated to 10.0.27.

It failed on step 23:

GlobalUpdate script for service model: AOSService on machine: MININT-Dev161
Sync AX database
02/18/2023 16:04:37: Caught unexpected exception: System.AggregateException: Unable to connect to SQL server. ---> System.Data.SqlClient.SqlException: Windows logins are not supported in this version of SQL Server. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool p

I can open database using SSMS with windows login.

tried restarting sql server service, starting sql server reporting services.  still not work.

Any ideas?

thanks

Alan

  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,439 Super User 2024 Season 2 on at
    Failed to apply update 10.0.31 on a local dev box 10.0.27
    Hi Alan,
     
    The issue could be due to either of the following:
    1. Either your database was restored from higher to the dev box and it has not been renamed as AxDB.
    2. Changes were made to the web.config file and your config settings (as per this link Debug a copy of the production database - Finance & Operations | Dynamics 365 | Microsoft Learn). Its pointing to the UAT or any Tier2/Tier 3 environment.
     
    Happy to answer questions, if any.
  • Suggested answer
    MuthukumaranAX Profile Picture
    MuthukumaranAX 2,907 on at
    Failed to apply update 10.0.31 on a local dev box 10.0.27
    Did you change the database information in "web.config" file? Can you try to perform sync database from VS and check if you receive any error?
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,347 Super User 2024 Season 2 on at
    Failed to apply update 10.0.31 on a local dev box 10.0.27
    Hi Alan,
     
    Did you download VC++ as guy said? Please check out this blog I wrote about updating an environment 
     
     
    Thanks,
    Layan Jweihan 
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • Suggested answer
    Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    Failed to apply update 10.0.31 on a local dev box 10.0.27
    I can't help with the original query, but for the Community member asking about updating their DevBox to 10.0.38.... did you install the pre-requisite that was introduced before 10.0.36?
     
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,439 Super User 2024 Season 2 on at
    Failed to apply update 10.0.31 on a local dev box 10.0.27
    Hi,
    There are 2 possibilities in this case.
    1. Looks like in your development box the database was restored from a higher (Tier 3) to a Tier 1 development environment and some one failed to change the name of the database to AxDB. Can you check that?
    2. Also, check if you have the axdbadmin account working too post restoration of the database.  
  • Community member Profile Picture
    Community member 2 on at
    Failed to apply update 10.0.31 on a local dev box 10.0.27
    Hello Alan, 
    I am receiving same error when I trying to update my DevBox to MS10.0.38.

    Do you remember the solution ? 
    It would help me a lot and I will be grateful! 
  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,692 Most Valuable Professional on at
    RE: Failed to apply update 10.0.31 on a local dev box 10.0.27

    Hi Alan,

    Was the name of your VM renamed at any point in time?

    You could try to restart the VM and reapply the package.

    Another option you have, being a local VM, if to download a fresh VHD and migrate your objects.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans