SQL Login Error "provider: TCP Provider, error: 0 - The specified network name is no longer availab"
SQL Login Error "provider: TCP Provider, error: 0 - The specified network name is no longer availab"
We use Azure SQL with "Active Directory Interactive (with MFA support)" with "Azure App Settings" configured and are using version 2019.1.25.0 64bit.
Intermittently I get a connection error as below and screenshot, doesn't seem to be a pattern. It doesn't seem to be related to how long I take to go through the login process as I initially thought it might be a timeout issue.
Devolutions.RemoteDesktopManager.Business.TryGoOfflineException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.ExecuteScalar[T](String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetConnectionCacheID()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.HasSecurityChanged()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.c5ef36373244cdf2ba529a3f9d55c7fda(BaseConnectionDataSource c7f28727fc7a5daa94ba08f688b2a5781)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource, ConnectionEngine currentEngine)
rdm error.png
All Comments (3)
RDM still starts up and prompts to "Go Offline" and I can immediately click go online (Orange world icon bottom right on the status bar) and it will turn green.
It looks like an intermittent login/connection issue with Azure SQL. We will need to add more robust retry logic when the error occurs. In the mean time, "Go Offline" + "Go Online"/F5 is a work around.
Sorry for the inconvenience,
Best regards,
Stéfane Lavergne
I've implemented the retry logic and it will be available in the next beta release. If you could please give the new version a try (available next week or so build # must be v2020.1.7 or greater).
The build will be available here: https://remotedesktopmanager.com/home/download#Beta
Best regards,
Stéfane Lavergne