Blog | IT Tour

Workaround to manually install MSU file on Windows 10/1909 (Installer encountered an error: 0x80070422)

October 26, 2020 · One min read

Installer encountered an error: 0x80070422

The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.

C:\>mkdir C:\KB4577671
Expand –F:* C:\windows10.0-kb4577671-x64_2c354d18b910d565f23b7ede1ec971852f68d0df.msu C:\KB4577671
DISM.exe /Online /Add-Package /PackagePath:c:\KB4577671\Windows10.0-KB4577671-x64_PSFX.cab

https://stackoverflow.com/questions/35452549/install-windows-update-file-msu-without-having-windows-update-service-activa

System.Data.SqlClient.TdsParser.ThrowUnsupportedCollationEncountered when connecting to SqlServer by docker image aspnet:3.1.0-alpine

October 23, 2020 · 4 min read

<span id="LC1" class="line" lang="docker"><span class="k">FROM</span><span class="s"> mcr.microsoft.com/dotnet/core/aspnet:3.1.0-<span class="idiff left right">alpine</span></span></span>
<span id="LC2" class="line" lang="docker"><span class="k">COPY</span><span class="s"> . /app</span></span>
<span id="LC3" class="line" lang="docker"><span class="k">WORKDIR</span><span class="s"> /app</span></span>
<span id="LC4" class="line" lang="docker"></span>
<span id="LC5" class="line" lang="docker"><span class="k">EXPOSE</span><span class="s"> 5000/tcp</span></span>
<span id="LC6" class="line" lang="docker"><span class="k">ENV</span><span class="s"> ASPNETCORE_URLS http://*:5000</span></span>

<span id="LC11" class="line" lang="docker"><span class="k">ENTRYPOINT</span><span class="s"> ["dotnet", "XXXX.dll"]</span></span>

System.InvalidOperationException: Internal connection fatal error.
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.DrainData(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.ThrowUnsupportedCollationEncountered(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.GetCodePage(SqlCollation collation, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TryProcessEnvChange(Int32 tokenLength, TdsParserStateObject stateObj, SqlEnvChange& sqlEnvChange)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()

<span id="LC1" class="line" lang="docker"><span class="k">FROM</span><span class="s"> mcr.microsoft.com/dotnet/core/aspnet:3.1.0<span style="color: #ff0000;">-buster-slim</span></span></span>
<span id="LC2" class="line" lang="docker"><span class="k">COPY</span><span class="s"> . /app</span></span>
<span id="LC3" class="line" lang="docker"><span class="k">WORKDIR</span><span class="s"> /app</span></span>
<span id="LC4" class="line" lang="docker"></span>
<span id="LC5" class="line" lang="docker"><span class="k">EXPOSE</span><span class="s"> 5000/tcp</span></span>
<span id="LC6" class="line" lang="docker"><span class="k">ENV</span><span class="s"> ASPNETCORE_URLS http://*:5000</span></span>
<span id="LC7" class="line" lang="docker"></span>
<span id="LC11" class="line" lang="docker"><span class="k">ENTRYPOINT</span><span class="s"> ["dotnet", "XXXX.dll"]</span></span>

also occurs in image dotnet:2.1-aspnetcore-runtime : https://github.com/dotnet/dotnet-docker/issues/560 https://github.com/dotnet/SqlClient/issues/81#issuecomment-399375323 https://github.com/dotnet/dotnet-docker/issues/684

<span id="LC1" class="line" lang="docker"><span class="k">FROM</span><span class="s"> mcr.microsoft.com/dotnet/core/aspnet:3.1.0-<span class="idiff left right">alpine</span></span></span>
<span id="LC2" class="line" lang="docker"><span class="k">COPY</span><span class="s"> . /app</span></span>
<span id="LC3" class="line" lang="docker"><span class="k">WORKDIR</span><span class="s"> /app</span></span>
<span id="LC4" class="line" lang="docker"></span>
<span id="LC5" class="line" lang="docker"><span class="k">EXPOSE</span><span class="s"> 5000/tcp</span></span>
<span id="LC6" class="line" lang="docker"><span class="k">ENV</span><span class="s"> ASPNETCORE_URLS http://*:5000</span></span>
<span id="LC7" class="line" lang="docker"></span>
<span style="color: #ff0000;"><span id="LC8" class="line" lang="docker"><span class="k">RUN </span>apk add <span class="nt">--no-cache</span> icu-libs</span>
<span id="LC9" class="line" lang="docker"><span class="k">ENV</span><span class="s"> DOTNET_SYSTEM_GLOBALIZATION_INVARIANT=false</span></span></span>
<span id="LC10" class="line" lang="docker"></span>
<span id="LC11" class="line" lang="docker"><span class="k">ENTRYPOINT</span><span class="s"> ["dotnet", "XXXX.dll"]</span></span>