none
Database Experimentation Assistant - can't get it to connect to SQL Server RRS feed

  • Question

  • I am working to get Database Experimentation Assistant connected to my SQL Server so I can capture a trace. However, no matter what I try, it refuses to connect to the server. The SQL Server and the workstation are both Azure VM's, in the same VNet but different subnets. I have ensured that all traffic is allowed to flow through the entire VNet at the NSG level. I have created a Windows Firewall rule on the SQL Server allowing all traffic from that specific VM to flow through. 

    Using SQLTest.exe, I was able to successfully establish a connection from the workstation to the SQL Server and run queries. However, when I use DAE with the same exact connection details - same host, user, password, etc - I continuously get a connection error specifying Named Pipes (see below). Well I have Named Pipes disabled and I am entering the hostname as "tcp:10.10.0.1,1433" (i tried other variations), and I am using SQL authentication, but still it continues to give me the error about Named Pipes.

    What can I do to get past this first hiccup? I am including the error details from the DEA log below:

    DEA Information: 0 : TraceEvent, 04/27/2019 00:20:31, Data: {"Message":"AppStarted","Timestamp":"2019-04-27T00:20:31.3201259Z"}
    DEA Information: 0 : TraceEvent, 04/27/2019 00:20:31, Data: {"Message":"OS:Microsoft Windows NT 6.2.9200.0, App name:DEA.exe, App version:2.6.61459.2","Timestamp":"2019-04-27T00:20:31.4920001Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:20:31, Data: {"Message":"Entered GetNewVersion","Timestamp":"2019-04-27T00:20:31.6482504Z"}
    DEA Information: 0 : MetricEvent, 04/27/2019 00:20:32, Data: {"IsSuccess":false,"Name":"Duration","StartTime":"2019-04-27T00:20:31.6482504Z","Value":547.10210000000006,"Operation":"GetNewVersion","Timestamp":"2019-04-27T00:20:32.1979391Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:20:32, Data: {"Message":"Exited GetNewVersion","Timestamp":"2019-04-27T00:20:32.1979391Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:21:21, Data: {"Message":"Entered GetSqlServerConnectionMetaData","Timestamp":"2019-04-27T00:21:21.9195203Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:21:21, Data: {"Message":"Attempting to get the SQL server metadata.","Operation":"CaptureModel","Properties":{"ServerRoleName":null,"ProductVersion":null,"TraceId":"0","SelectedDuration":"5","TraceType":"Minimum","CaptureStartTime":"1/1/0001 12:00:00 AM","CaptureStopTime":"1/1/0001 12:00:00 AM","CaptureDuration":"00:05:00","CaptureStatus":"NotStarted","ErrorCode":"0","PreprocessTraceStatus":"NotStarted","ReplayStatus":"NotStarted","Id":"dd3903d1-02ad-497c-939b-392e969dd134"},"Timestamp":"2019-04-27T00:21:21.9195203Z"}
    DEA Error: -2146232060 : ExceptionEvent, 04/27/2019 00:21:53, Data: {"Code":-2146232060,"Message":"Exception while executing query.","Timestamp":"2019-04-27T00:21:53.6596312Z"}, Exception: 
    [Exception Info]:System.Data.SqlClient.SqlException, Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     StackTrace:   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
       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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteReader(IDbCommandDefinition sqlCommandDefinition, String connectionstring)System.ComponentModel.Win32Exception[InnerException]:
     Message:The network path was not found 
     StackTrace:
    DEA Error: -2146232060 : ExceptionEvent, 04/27/2019 00:21:53, Data: {"Code":-2146232060,"Message":"Unable to get Sql Server memory information.","Timestamp":"2019-04-27T00:21:53.6746528Z"}, Exception: 
    [Exception Info]:System.Data.SqlClient.SqlException, Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     StackTrace:   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
       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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteReader(IDbCommandDefinition sqlCommandDefinition, String connectionstring)
       at Microsoft.DEA.BusinessLogic.Actions.GetSqlServerConnectionMetaData.GetSqlServerSystemAndMemoryInfo()System.ComponentModel.Win32Exception[InnerException]:
     Message:The network path was not found 
     StackTrace:
    DEA Information: 0 : TraceEvent, 04/27/2019 00:21:53, Data: {"Message":"Successfully retrieved SQL server metadata.","Operation":"CaptureModel","Properties":{"ServerRoleName":"sysadmin","ProductVersion":"13.0.4522.0","TraceId":"0","SelectedDuration":"5","TraceType":"Minimum","CaptureStartTime":"1/1/0001 12:00:00 AM","CaptureStopTime":"1/1/0001 12:00:00 AM","CaptureDuration":"00:05:00","CaptureStatus":"NotStarted","ErrorCode":"0","PreprocessTraceStatus":"NotStarted","ReplayStatus":"NotStarted","Id":"dd3903d1-02ad-497c-939b-392e969dd134"},"Timestamp":"2019-04-27T00:21:53.6766364Z"}
    DEA Information: 0 : MetricEvent, 04/27/2019 00:21:53, Data: {"IsSuccess":false,"Name":"Duration","StartTime":"2019-04-27T00:21:21.9195203Z","Value":31754.9765,"Operation":"GetSqlServerConnectionMetaData","Timestamp":"2019-04-27T00:21:53.6776292Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:21:53, Data: {"Message":"Exited GetSqlServerConnectionMetaData","Timestamp":"2019-04-27T00:21:53.6776292Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:21:53, Data: {"Message":"Entered VerifyUserServerRoleName","Timestamp":"2019-04-27T00:21:53.6776292Z"}
    DEA Information: 0 : MetricEvent, 04/27/2019 00:21:53, Data: {"IsSuccess":false,"Name":"Duration","StartTime":"2019-04-27T00:21:53.6776292Z","Value":0.3921,"Operation":"VerifyUserServerRoleName","Timestamp":"2019-04-27T00:21:53.6776292Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:21:53, Data: {"Message":"Exited VerifyUserServerRoleName","Timestamp":"2019-04-27T00:21:53.6786305Z"}
    DEA Information: 0 : DiagnosticEvent, 04/27/2019 00:21:53, Data: {"Message":"Entered VerifyDatabaseExists","Timestamp":"2019-04-27T00:21:53.6786305Z"}
    DEA Error: -2146232060 : ExceptionEvent, 04/27/2019 00:21:53, Data: {"Code":-2146232060,"Message":"Exception while executing query.","Timestamp":"2019-04-27T00:21:53.680643Z"}, Exception: 
    [Exception Info]:System.Data.SqlClient.SqlException, Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     StackTrace:   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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteScalar(IDbCommandDefinition sqlCommandDefinition, String connectionstring)System.ComponentModel.Win32Exception[InnerException]:
     Message:The network path was not found 
     StackTrace:
    DEA Information: 0 : MetricEvent, 04/27/2019 00:21:53, Data: {"IsSuccess":true,"Name":"Duration","StartTime":"2019-04-27T00:21:53.6786305Z","Value":2.3451,"Operation":"VerifyDatabaseExists","Timestamp":"2019-04-27T00:21:53.680643Z"}
    DEA Error: -2146232060 : ExceptionEvent, 04/27/2019 00:21:53, Data: {"Code":-2146232060,"Message":"SQL Exception occurred while starting trace on the server.","Timestamp":"2019-04-27T00:21:53.6816305Z"}, Exception: 
    [Exception Info]:System.Data.SqlClient.SqlException, Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     StackTrace:   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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteScalar(IDbCommandDefinition sqlCommandDefinition, String connectionstring)
       at Microsoft.DEA.BusinessLogic.Actions.VerifyDatabaseExists.Run()
       at Microsoft.DEA.BusinessLogic.ActionDecorator.<>c__DisplayClass2_0.<Run>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.<Run>d__2.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at Microsoft.DEA.BusinessLogic.ActionDecorator.<Run>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.<RunAsync>d__12.MoveNext()System.ComponentModel.Win32Exception[InnerException]:
     Message:The network path was not found 
     StackTrace:
    DEA Error: -2146233088 : ExceptionEvent, 04/27/2019 00:21:53, Data: {"Code":-2146233088,"Message":"Exception has occurred while starting the trace on server.","Operation":"CaptureModel","Properties":{"ServerRoleName":"sysadmin","ProductVersion":"13.0.4522.0","TraceId":"0","SelectedDuration":"5","TraceType":"Minimum","CaptureStartTime":"1/1/0001 12:00:00 AM","CaptureStopTime":"1/1/0001 12:00:00 AM","CaptureDuration":"00:05:00","CaptureStatus":"NotStarted","ErrorCode":"0","PreprocessTraceStatus":"NotStarted","ReplayStatus":"NotStarted","Id":"dd3903d1-02ad-497c-939b-392e969dd134"},"Timestamp":"2019-04-27T00:21:53.6866307Z"}, Exception: 
    [Exception Info]:Microsoft.DEA.Common.Exceptions.DeaException, Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     StackTrace:   at Microsoft.DEA.BusinessLogic.Bootstrappers.CaptureTrace.<RunAsync>d__12.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.<StartWorkflowAsync>d__37.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.<CreateCaptureBootstrapperAsync>d__24.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.UI.ViewModels.MainRegion.NewCaptureViewModel.<StartTraceAsync>d__104.MoveNext()System.Data.SqlClient.SqlException[InnerException]:
     Message:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
     StackTrace:   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, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.DEA.DataAccess.SqlDbRepository.ExecuteScalar(IDbCommandDefinition sqlCommandDefinition, String connectionstring)
       at Microsoft.DEA.BusinessLogic.Actions.VerifyDatabaseExists.Run()
       at Microsoft.DEA.BusinessLogic.ActionDecorator.<>c__DisplayClass2_0.<Run>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.<Run>d__2.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
       at Microsoft.DEA.BusinessLogic.ActionDecorator.<Run>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.<RunAsync>d__12.MoveNext()
    [InnerException]:System.ComponentModel.Win32Exception Message:The network path was not found 
     StackTrace:

    Saturday, April 27, 2019 12:32 AM

Answers

  • I fixed it! I added a HOSTS file entry pointing to the DB server's hostname, and used the hostname instead of an IP address. It seems like using the IP prevents DEA from connecting properly...
    • Marked as answer by noamo48 Monday, April 29, 2019 3:29 PM
    Monday, April 29, 2019 3:29 PM

All replies

  • Hi noamo48,

    Could you try to specify <servername> or <servername><instancename> to test the connection by using sqlcmd? And please refer to SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, April 29, 2019 3:20 AM
  • I have tried everything listed there and tried different variations of the server name but I still get the same error. Why is it trying to connect with named pipes? I get that named pipes error even though I'm specifying TCP in the server name (i.e. "tcp:10.0.0.1,1433"). The odd thing is that if I put invalid credentials, it tells me that the login doesn't work. But if I have valid credentials, then it tells me "The server was not found or was not accessible. ".
    Monday, April 29, 2019 3:08 PM
  • I fixed it! I added a HOSTS file entry pointing to the DB server's hostname, and used the hostname instead of an IP address. It seems like using the IP prevents DEA from connecting properly...
    • Marked as answer by noamo48 Monday, April 29, 2019 3:29 PM
    Monday, April 29, 2019 3:29 PM