Forum Discussion

answeriver's avatar
answeriver
Icon for Helper IV rankHelper IV
6 years ago

Mi SQL SERVER NO PUEDE Conectar

Necesita ayuda lo antes posible. No se puede conectar ya dos semanas, y el proyecto ya comenzó Necesito conectarme a MySQL (en el lado del proveedor). Conector instalado (hace dos meses alreadry ut...
answeriver's avatar
answeriver
Icon for Helper IV rankHelper IV
6 years ago

@mwegener

gracias por el enlace, tengo archivo de registro, pero no entiendo todo esto.

Actauly, si el srever tiene dos pasos autentificación, pero sólo uso uno. Tal vez necesito el comando sql que necesito usar en primer lugar la contraseña del servidor&

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hola @answeriver

¿puede compartir los archivos de registro con nosotros?

  • answeriver's avatar
    answeriver
    Icon for Helper IV rankHelper IV
    6 years ago

    @mwegener sí. Abajo

    bjectCacheSessions/Data/CacheStats/Size ?"Start":"2020-04-22T02:24:48.9996114Z","Action":"ObjectCacheSessions/Data/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.79.5768.721 (20.03)))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03)))(20.03)))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03)))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03))(20.03))(20 ","ActivityId":"00000000-0000-0000-0000-00000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0001336"
    ObjectCacheSessions/Data/CacheStats/Access ?"Start":"2020-04-22T02:24:49.0001835Z","Action":"ObjectCacheSessions/Data/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.79.5768.721 (20.083)","ActivityId":"00000000-0000-0000-00000-0000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0000342"
    SimpleDocumentEvaluator/GetResult/Compile ?"Start":"2020-04-22T02:24:49.1038888Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)",""""",""""""""""""",""""""""","""""""""""""""""""""""""""""""""""""""""""""""""""""""","""""""""""""""""""""""""""""""""""""""""","""""""""""""""""""""".""""""""""""""""""""""""""""""."""""""""""ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.4145351"
    SimpleDocumentEvaluator/GetResult/Evaluate "Start":"2020-04-22T02:24:49.5184469Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","""""",""""""""""",""""""""""",""""""""""""""""""""""""""""""""""""""""""""""""""""""""","""""""""""""""""""""""""""""""""""""""""""",""""""""""""""""""""."""""""""""""""""""""""""""""""""""""""""ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.1349693"
    Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T02:24:49.9025998Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","Exception":"Exception:rnExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44drnMessage: Reading from the stream has failed.rnStackTrace:n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()rn at MySql.Data.MySqlClient.MySqlStream.ReadPacket()rn at MySql.Data.MySqlClient.NativeDriver.Open()rn at MySql.Data.MySqlClient.Driver.Open()rn at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)rn at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()rn at MySql.Data.MySqlClient.MySqlPool.GetConnection()rn at MySql.Data.MySqlClient.MySqlConnection.Open()rn at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method , Func'2 func)-r-n-nInnerException-r-nExceptionType: System.IO.EndOfStreamException, mscorlib, Version-4.0.0.0, Culture-neutral, PublicKeyToken-b77a5c561934e089-r-nMensaje: Se ha intentado leer más allá del final de la secuencia. Byte[] buffer, Int32 offset, Int32 count)-r-n en MySql.Data.MySqlClient.MySqlStream.LoadPacket()-r-n-n-n-n-n-r-n","Product Versión":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b782763333","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:01:00.0062782"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T02:25:49.9379593Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql ","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0002775"
    Motor/IO/Db/MySQL/Connection/Dispose ?"Start":"2020-04-22T02:25:49.9382607Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql ","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"252fae01-4daf-411d-b633-457b8a276d6c","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000062"
    Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T02:25:49.9741917Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","Exception":"Exception:rnExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44drnMessage: Reading from the stream has failed.rnStackTrace:n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()rn at MySql.Data.MySqlClient.MySqlStream.ReadPacket()rn at MySql.Data.MySqlClient.NativeDriver.Open()rn at MySql.Data.MySqlClient.Driver.Open()rn at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)rn at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()rn at MySql.Data.MySqlClient.MySqlPool.GetConnection()rn at MySql.Data.MySqlClient.MySqlConnection.Open()rn at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method , Func'2 func)-r-n-nInnerException-r-nExceptionType: System.IO.EndOfStreamException, mscorlib, Version-4.0.0.0, Culture-neutral, PublicKeyToken-b77a5c561934e089-r-nMensaje: Se ha intentado leer más allá del final de la secuencia. Byte[] buffer, Int32 offset, Int32 count)-r-n en MySql.Data.MySqlClient.MySqlStream.LoadPacket()-r-n-n-n-n-n-r-n","Product Versión":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276 3353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9248355"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T02:26:49.8995732Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000339"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T02:26:49.8996452Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"bf238437-7d29-4f5f-b517-ea805096cecf","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000141"
    SimpleDocumentEvaluator/GetResult<IPreviewValueSource> "Start":"2020-04-22T02:24:49.1016097Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""."""""""""""""""""""""""""""."""ProductVersion":"2.79 ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:02:00.7904630"
    FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> "Start":"2020-04-22T02:24:49.0253167Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"00aa24eb-61a3-464e-948c-c44b78276353","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.6298648"
    SimpleDocumentEvaluator/GetResult/Compile ?"Start":"2020-04-22T03:23:42.5786061Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)"" "ActivityId":"6abedb333-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0114522"
    SimpleDocumentEvaluator/GetResult/Evaluate ?"Start":"2020-04-22T03:23:42.5903285Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)"" "ActivityId":"6abedb333-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:00.0001891"
    Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T03:23:42.5933473Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","Exception":"Exception:rnExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44drnMessage: Reading from the stream has failed.rnStackTrace:n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()rn at MySql.Data.MySqlClient.MySqlStream.ReadPacket()rn at MySql.Data.MySqlClient.NativeDriver.Open()rn at MySql.Data.MySqlClient.Driver.Open()rn at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)rn at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()rn at MySql.Data.MySqlClient.MySqlPool.GetConnection()rn at MySql.Data.MySqlClient.MySqlConnection.Open()rn at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method , Func'2 func)-r-n-nInnerException-r-nExceptionType: System.IO.EndOfStreamException, mscorlib, Version-4.0.0.0, Culture-neutral, PublicKeyToken-b77a5c561934e089-r-nMensaje: Se ha intentado leer más allá del final de la secuencia. Byte[] buffer, Int32 offset, Int32 count)-r-n en MySql.Data.MySqlClient.MySqlStream.LoadPacket()-r-n-n-n-n-n-r-n","Product Versión":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e 44","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9123595"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T03:24:42.5059085Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000142"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T03:24:42.5059301Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"008566b0-f686-42e8-850d-30abbb06bfa2","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000108"
    Engine/IO/Db/MySQL/Connection/Open {"Start":"2020-04-22T03:24:42.5066378Z","Action":"Engine/IO/Db/MySQL/Connection/Open","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","Exception":"Exception:rnExceptionType: MySql.Data.MySqlClient.MySqlException, MySql.Data, Version=8.0.18.0, Culture=neutral, PublicKeyToken=c5687fc88969c44drnMessage: Reading from the stream has failed.rnStackTrace:n at MySql.Data.MySqlClient.MySqlStream.LoadPacket()rn at MySql.Data.MySqlClient.MySqlStream.ReadPacket()rn at MySql.Data.MySqlClient.NativeDriver.Open()rn at MySql.Data.MySqlClient.Driver.Open()rn at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)rn at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()rn at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()rn at MySql.Data.MySqlClient.MySqlPool.GetConnection()rn at MySql.Data.MySqlClient.MySqlConnection.Open()rn at Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass19_0.<TracePerformance>b__0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method , Func'2 func)-r-n-nInnerException-r-nExceptionType: System.IO.EndOfStreamException, mscorlib, Version-4.0.0.0, Culture-neutral, PublicKeyToken-b77a5c561934e089-r-nMensaje: Se ha intentado leer más allá del final de la secuencia. Byte[] buffer, Int32 offset, Int32 count)-r-n en MySql.Data.MySqlClient.MySqlStream.LoadPacket()-r-n-n-n-n-n-r-n","Product Versión":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e 44","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:00:59.9998182"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T03:25:42.5068040Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000491"
    Motor/IO/Db/MySQL/Connection/Dispose "Start":"2020-04-22T03:25:42.5068746Z","Action":"Engine/IO/Db/MySQL/Connection/Dispose","ResourceKind":"MySql","ResourcePath":"78.40.109.204:443;youniverse","HostProcessId":"21224","ConnectionId":"8d0a0cab-7894-4e25-9b37-f2a603bb9391","ProductVersion":"2.79.5768.721 (20.03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Proceso":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0000139"
    SimpleDocumentEvaluator/GetResult<IPreviewValueSource> "Start":"2020-04-22T03:23:42.5785933Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)",","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)",","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)",",""."".""."",""."""""""""ProductVersion":"2.79.5768.721 (20.03)",",""HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.03)",","HostProcessId":"21224","ProductVersion":"2 "ActivityId":"6abedb333-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duration":"00:01:59.9285806"
    FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> "Start":"2020-04-22T03:23:42.5781114Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","HostProcessId":"21224","ProductVersion":"2.79.5768.721 (20.20.721 (20.20.721 (20.20.721 (20.20.721 (20.20.721 (20.20.721 (20.57.5768.721 (20.20.721 (20.57.5768.721 (20.20.721 (20.5768.721 (20.20.721 (20.5768.721 (20.79.5768.721 (20.721 (20..678.721 (20.20.721 (20.79.5768.721 (2 03)","ActivityId":"6abedb33-6872-47b3-bfc2-04d63cc8e9e4","Process":"Microsoft.Mashup.Container.NetFX45","Pid":17104,"Tid":1,"Duración":"00:00:00.0124273"