Unable to Connect to SQL Server

This just started happening to me too.

I have version Version: 2.43.4647.541 64-bit (February, 2017) installed.

The first database I connected to when I first installed worked just fine for weeks.

Then, today, I tried to connect to a different server and this error started to happen.

Now, I cannot connnect to any server, even the original one.

This is not an issue of permissions of any kind, nor of any database settings such as allow remote connection/login.

I have two trace files for you, but I cannot see anywhere to load an attachment, and only one will fit in this post.

Here is file (Microsoft.Mashup.Container.NetFX40.7900.2017-03-03T18-42-54-198131.log)

DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2570565Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0026425"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2581047Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0057521"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2639278Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0002807"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2659280Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0002288"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2657995Z","Action":"CredentialExtensions/GetImpersonationWrapper","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0372305"}
DataMashup.Trace Error: 24579 : {"Start":"2017-03-03T18:42:54.3108133Z","Action":"Engine/IO/Db/SQL/ProcessException","Exception":"Exception:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0272186"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3098370Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0285287"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3093584Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0296035"}
DataMashup.Trace Error: 24579 : {"Start":"2017-03-03T18:42:54.3407557Z","Action":"Engine/IO/Db/SQL/ProcessException","Exception":"Exception:\r\nExceptionType: System.IO.FileLoadException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: \r\nStackTrace:\n   at System.Data.ProviderBase.DbConnectionPool.TransactedConnectionPool..ctor(DbConnectionPool pool)\r\n   at System.Data.ProviderBase.DbConnectionPool..ctor(DbConnectionFactory connectionFactory, DbConnectionPoolGroup connectionPoolGroup, DbConnectionPoolIdentity identity, DbConnectionPoolProviderInfo connectionPoolProviderInfo)\r\n   at System.Data.ProviderBase.DbConnectionPoolGroup.GetConnectionPool(DbConnectionFactory connectionFactory)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPool(DbConnection owningObject, DbConnectionPoolGroup connectionPoolGroup)\r\n   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n   at System.Data.SqlClient.SqlConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.RunWithRetryGuard[T](Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n   at Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action, Func`2 retryAfterSqlError, Action finalizeOnRetry, String dataSourceNameString, IEngineHost host)\r\n\r\n\r\n","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0002405"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3401397Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0010471"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3399958Z","Action":"Engine/IO/Db/Microsoft SQL/RunWithRetry","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0014186"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2580756Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0831198"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2574493Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0068143"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2643074Z","Action":"RemotePreviewValueSource/RunStub","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0777113"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.2572071Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"11","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"efe5f3d1-262c-41e8-a122-e682e62d5715","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":1,"Duration":"00:00:00.0848898"}
DataMashup.Trace Information: 24579 : {"Start":"2017-03-03T18:42:54.3422285Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.43.4647.541 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":7900,"Tid":16,"Duration":"00:00:00.0002062"}