SQLTeam.com | Weblogs | Forums

Data Experimentation Assistant, The certificate chain was issued by an authority that is not trusted

sql2016

#1

I try to run deacmd but I get the following error:

C:\Program Files (x86)\Microsoft Corporation\Database Experimentation Assistant>deacmd -o startcapturetrace -s localhost -d FTS_LIVE_LOCAL_2008 -p C:\TraceFiles -f Trace1 -t 1
DEA Information: 0 : TraceEvent, 03/12/2018 08:53:41, Data: AppStarted
DEA Information: 0 : DiagnosticEvent, 03/12/2018 08:53:41, Data: Entered GetSqlServerConnectionMetaData
DEA Information: 0 : DiagnosticEvent, 03/12/2018 08:53:41, Data: Attempting to get the SQL server metadata.
DEA Error: -2146232060 : ExceptionEvent, 03/12/2018 08:53:42, Data: Exception while executing query., Exception:
[Exception Info]:System.Data.SqlClient.SqlException, Message: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.)
StackTrace: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString user
ConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
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, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteReader(IDbCommandDefinition sqlCommandDefinition, String connectionstring)System.ComponentModel.
Win32Exception[InnerException]:
Message:The certificate chain was issued by an authority that is not trusted
StackTrace:
DEA Error: -2146233088 : ExceptionEvent, 03/12/2018 08:53:42, Data: Unable to connect to the SQL Server during pre-login handshake, certificate was either issued by an authority that is not trusted or expired. Check TrustServerCertificate to use a self-signed server certificate. | Sql Error Code (-2
146893019), Exception:[Exception Info]:Microsoft.DEA.Common.Exceptions.DeaException, Message:Exception occurred while connecting to the server during pre-login handshake, the certificate chain was issued by an authority that is not trusted.
StackTrace: at Microsoft.DEA.BusinessLogic.Actions.GetSqlServerConnectionMetaData.GetSqlServerInfo()
at Microsoft.DEA.BusinessLogic.Actions.GetSqlServerConnectionMetaData.Run()
at Microsoft.DEA.BusinessLogic.ActionDecorator.<>c__DisplayClass2_0.b__0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.ActionDecorator.d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.DEA.BusinessLogic.ActionDecorator.d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.Bootstrappers.CaptureTrace.d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.DEA.BusinessLogic.Bootstrappers.CaptureTrace.d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.BootstrapperFactory.d__33.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.BusinessLogic.BootstrapperFactory.d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.CommandLine.StartCaptureOperation.d__31.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DEA.CommandLine.Dea.d__10.MoveNext()System.Data.SqlClient.SqlException[InnerException]:
Message: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.)
StackTrace: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString user
ConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
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, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteReader(IDbCommandDefinition sqlCommandDefinition, String connectionstring)
at Microsoft.DEA.BusinessLogic.Actions.GetSqlServerConnectionMetaData.GetSqlServerInfo()
[InnerException]:System.ComponentModel.Win32Exception Message:The certificate chain was issued by an authority that is not trusted
StackTrace:
DEA Information: 0 : TraceEvent, 03/12/2018 08:53:42, Data: AppExited

Connecting to that database with Windows authentication succeeds. Why does not DEA succeed?