Supply chain | Supply Chain Management, Commerce

Failed to apply update 10.0.31 on a local dev box 10.0.27

(0) Share

Report

Posted on by Alan Zhou

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Komi Siabi 13,107 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,430 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

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?

New VC++ runtime requirement for cloud-hosted environments running version 10.0.36 or later - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi Alan,

Did you download VC++ as guy said? Please check out this blog I wrote about updating an environment

https://www.ljdynamicswritings.com/2023/12/update-d365fo-environments-to-new-microsoft-version.html?m=1

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

Was this reply helpful? Yes No
Suggested answer

MuthukumaranAX 2,903 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,430 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No