Skip to main content
Supply Chain Management forum
Suggested answer

Failed to apply update 10.0.31 on a local dev box 10.0.27

editSubscribe (0) ShareShare
ReportReport
Posted on by 55

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,164 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,893 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 2,785 Super User 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
    GuyUK Profile Picture
    GuyUK 28,100 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,164 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.  
  • 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,239 Super User 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.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans