Mi SQL SERVER NO PUEDE Conectar

mwegener
Most Valuable Professional
6 years ago
Hola @answeriver

¿puede compartir los archivos de registro con nosotros?
- answeriver
  Helper 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"
mwegener
Most Valuable Professional
6 years ago
Hola @answeriver ,

No pude encontrar nada en el archivo de registro.

No conozco la autenticación de dos pasos, ¿puede describirla más?

¿Utiliza certificados SSL?

https://community.powerbi.com/t5/Power-Query/How-to-connect-to-a-datasource-with-SSL/m-p/671941
- answeriver
  Helper IV
  6 years ago
  @mwegener ssl no utilizar.
  El origen de datos tiene dos pasos de credenciales (como dice el proveedor)
  El primero es para entrar en el servidor
  En segundo lugar es para la base de datos que necesito.
  Creo que todo el problema en mi situación es que el proveedor no sabe acerca de power bi, es por eso que no me ayuda en este

Forum Discussion

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