Hi suresh
This client has also stablished same structure in 2 physicals servers .
the point is they are not adding the internal ip in their vpn because the subdomain of physical and azure servers are conflicting .
Each time issue can be solved after restarting the servers
While opening the database i got 3 derrent errors
1 server not found
2--------------------------- Microsoft Dynamics NAV Development Environment --------------------------- The following SQL Server error or errors occurred: -2146892976,"HY000",[MicrosoSQL Server Network Interfaces: The system cannot contact a domain controller to service the authentication request. Please try again later. -2146892976,"HY000",[Microsoft][SQL Server Native Client 11.0]Cannot generate SSPI context --------------------------- OK ---------------------------
3---------------------------- Microsoft Dynamics NAV Development Environment --------------------------- The following SQL Server error or errors occurred: 18452,"28000",[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. --------------------------- OK ---------------------------
i have checked the event log could not find proper solution
2.4.3 pm The Desktop Window Manager has registered the session port.
2.4.3 pm The winlogon notification subscriber <NTDS> was unavailable to handle a critical notification
2.5.53 pm Message: The network path was not found
Below is detailed error
Server instance: ****
Tenant ID:
User: *****
Type: System.Data.SqlClient.SqlException
ClientConnectionId: 00000000-0000-0000-0000-000000000000
Class: 20
LineNumber: 0
Number: 53
State: 0
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
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.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.TryConnect()
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.<>c__DisplayClass15.<ExecuteAction>b__14()
HResult: -2146232060
----------------------------------
Type: System.ComponentModel.Win32Exception
NativeErrorCode: 53
ErrorCode: -2147467259
Message: The network path was not found
HResult: -2147467259
