trying to apply re-provisioning tool manually on a Local VHD, getting error
i even added to the connection string TrustServerCertificate=True, also at SQL instance trust server certificate checkbox is checked,
still issue persists
stack trace from error log
Redirecting to Retail Retargeting Tool V2
2020-04-23T09:12:49 : Retail Retargeting Tool - V2 . Last Updated Date: 2019-03-12.
2020-04-23T09:12:50 : Retail Retargeting Tool - GetRetailRetargetingConfiguration - V2 . Last Updated Date: 2018-12-28.
2020-04-23T09:12:50 : Checking HKLM:\SOFTWARE\Microsoft\Dynamics\7.0\RetailSelfService\Servicing for app insights keys.
2020-04-23T09:12:50 : Retail Servicing registry key HKLM:\SOFTWARE\Microsoft\Dynamics\7.0\RetailSelfService\Servicing found, using app insights keys from registry.
2020-04-23T09:12:50 : Done with extracting app insights keys from registry.
Opening connection to localhost/AxDB with user axdeployuser
2020-04-23T09:12:50 : Retargeting failed
2020-04-23T09:12:50 :
PSMessageDetails :
Exception : System.Management.Automation.MethodInvocationException: Exception calling "Open" with "0"
argument(s): "A connection was successfully established with the server, but then an error
occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain
was issued by an authority that is not trusted.)" ---> System.Data.SqlClient.SqlException: A
connection was successfully established with the server, but then an error occurred during the
login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an
authority that is not trusted.) ---> System.ComponentModel.Win32Exception: The certificate
chain was issued by an authority that is not trusted
--- End of inner exception stack trace ---
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
pool, String accessToken, Boolean applyTransientFaultHandling,
SqlAuthenticationProviderManager sqlAuthProviderManager)
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.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at CallSite.Target(Closure , CallSite , Object )
--- End of inner exception stack trace ---
at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext
funcContext, Exception exception)
at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame
frame)
at
System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame
frame)
at
System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame
frame)
TargetObject :
CategoryInfo : NotSpecified: (:) [], MethodInvocationException
FullyQualifiedErrorId : SqlException
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Update-SQLUserPassword, K:\DeployablePackages\RetailRetargetingTool\RetailServer\RetailServi
cingTools\RetailServicingTools.psm1: line 1095
at <ScriptBlock>, K:\DeployablePackages\RetailRetargetingTool\RetailServer\EnvironmentRetarget\
RetargetRetailServer.ps1: line 55
at <ScriptBlock>,
K:\DeployablePackages\RetailRetargetingTool\RetailServer\scripts\RetargetRetailServer.ps1:
line 20
at <ScriptBlock>, <No file>: line 3
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}
try{
$erroractionpreference = 'stop';
&
'K:\DeployablePackages\RetailRetargetingTool\RetailServer\scripts\RetargetRetailServer.ps1'
}
catch
{
$erroractionpreference = 'Continue';
Write-Error ($_ | Format-List * -Force | Out-String -Width 4096);
[Environment]::Exit(999)
} :
PSMessageDetails :
Exception : System.Management.Automation.MethodInvocationException: Exception calling "Open" with "0"
argument(s): "A connection was successfully established with the server, but then an error occurred during the login
process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"
---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error
occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an
authority that is not trusted.) ---> System.ComponentModel.Win32Exception: The certificate chain was issued by an
authority that is not trusted
--- End of inner exception stack trace ---
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 pool, String accessToken, Boolean applyTransientFaultHandling,
SqlAuthenticationProviderManager sqlAuthProviderManager)
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.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at CallSite.Target(Closure , CallSite , Object )
--- End of inner exception stack trace ---
at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext
funcContext, Exception exception)
at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame
frame)
at
System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
at
System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
TargetObject :
CategoryInfo : NotSpecified: (:) [], MethodInvocationException
FullyQualifiedErrorId : SqlException
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Update-SQLUserPassword,
K:\DeployablePackages\RetailRetargetingTool\RetailServer\RetailServicingTools\RetailServicingTools.psm1: line 1095
at <ScriptBlock>,
K:\DeployablePackages\RetailRetargetingTool\RetailServer\EnvironmentRetarget\RetargetRetailServer.ps1: line 55
at <ScriptBlock>,
K:\DeployablePackages\RetailRetargetingTool\RetailServer\scripts\RetargetRetailServer.ps1: line 20
at <ScriptBlock>, <No file>: line 3
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}
At line:1 char:1
+ &{ try{
+ ~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException
