Mi SQL SERVER NO PUEDE Conectar

Question

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 utilizaba este servidor). Pero en el nuevo equipo de seguridad del proyecto realiza cambios para el servidor de seguridad.

Así que ahora tengo:

inicio de sesión y contraseña de My SQL Server

inicio de sesión y contraseña de la base de datos (que necesito) en este servidor

Puerto que necesito usar.

Pero todo no es trabajo. Y obtengo este error

¿Qué puedo hacer?

mwegener · Answer

Hola @answeriver ,
 
permitir el seguimiento para obtener más información.
https://docs.microsoft.com/en-us/power-bi/desktop-troubleshooting-sign-in#how-to-collect-a-trace-in-power-bi-desktop

greg_deckler · Answer

https://bugs.mysql.com/bug.php?id=75917
 
http://www.voidcn.com/article/p-phfoefri-bpr.html
 
https://stackoverflow.com/questions/26652833/reading-from-the-stream-has-failed-mysqlexception
 
Hay una gran cantidad de información por ahí sobre los errores con esto por lo que puede ser un problema con su versión de MySQL

answeriver · Answer

@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 · Answer

Hola @answeriver
 
¿puede compartir los archivos de registro con nosotros?

answeriver · Answer

@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.&lt;Open&gt;b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.&lt;&gt;c__DisplayClass19_0.&lt;TracePerformance&gt;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.&lt;Open&gt;b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.&lt;&gt;c__DisplayClass19_0.&lt;TracePerformance&gt;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&lt;IPreviewValueSource&gt; "Start":"2020-04-22T02:24:49.1016097Z","Action":"SimpleDocumentEvaluator/GetResult&lt;IPreviewValueSource&gt;","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&lt;Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource&gt; "Start":"2020-04-22T02:24:49.0253167Z","Action":"FirewallDocumentEvaluator/GetResult&lt;Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource&gt;","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.&lt;Open&gt;b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.&lt;&gt;c__DisplayClass19_0.&lt;TracePerformance&gt;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.&lt;Open&gt;b__3_0(IHostTrace trace)rn at Microsoft.Mashup.Engine1.Library.Common.Tracer.&lt;&gt;c__DisplayClass19_0.&lt;TracePerformance&gt;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&lt;IPreviewValueSource&gt; "Start":"2020-04-22T03:23:42.5785933Z","Action":"SimpleDocumentEvaluator/GetResult&lt;IPreviewValueSource&gt;","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&lt;Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource&gt; "Start":"2020-04-22T03:23:42.5781114Z","Action":"FirewallDocumentEvaluator/GetResult&lt;Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource&gt;","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"

Forum Discussion

Mi SQL SERVER NO PUEDE Conectar

7 Replies

Related content

PowerBi Desktop - No se puede conectar

No se puede conectar a github

Power BI Report Server migration to new servers

EMERGENCIA || No se puede conectar SQL Server con PBI

Power BI Report Server licensing with SQL Server 2025 Standard when separating servers