Not being prompted to start in offline mode

Could you post the error log with the stack. Perhaps there is a path that is not verify for the offline mode.

Regards

It might be a day or two before I can get the app to do it again. I have already manually connected to the VPN and gotten RDM connected to the SQL database. If the issue is consistent, the app will work now, for a day or two, before doing what I described above. I will update this once I can provide the logs.

It took a little while to occur again but this morning, on my laptop, I was not prompted to start Remote Desktop Manager in offline mode. I am working remotely today so I need a VPN connection to connect to the SQL server.

You requested to post the "error log with the stack", can you elaborate on what you are looking for?

I just get a error window, "Unable to access the SQL Server database. Verify if you are offline or if you have an opened VPN."

Hello,


Do you have something relevant in Help -> View Application Log?

Please attached them to the topic.

Best regards,

Date: 6/21/2016 5:49:51 AM
Version: 11.5.4.0 - 32-bit
Type: Error
Message: System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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 Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetData(String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.GetDataSourceSettings()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.c29fbd34504079a3525ca4c390d5d4074(BaseConnectionDataSource cf40b69955d088020784eb92737f0a505)
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:-1,State:0,Class:20
****************************** SqlError ******************************
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)


Date: 6/21/2016 5:49:51 AM
Version: 11.5.4.0 - 32-bit
Type: Error Silent
Message: System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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 Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetData(String sql, IDbDataParameter[] parameters)
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.GetDataSourceSettings()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.c29fbd34504079a3525ca4c390d5d4074(BaseConnectionDataSource cf40b69955d088020784eb92737f0a505)
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:-1,State:0,Class:20

Hello,


Have you tried to uncheck the Prompt for offline mode on startup option in the Advanced tab of your data source configuration, click OK, restart RDM and reactivate the option to see if it's working again?

Best regards,

I have verified that the options is selected but I don't believe I have tried what you suggested. It will be a few days/weeks before the error occurs again. I have been resolving the issue by manually connecting to my VPN. Once the connection is up, the application will open in online mode, and it will prompt to start in offline mode the next time I open the application.

Hi,
I have verified our source code and the only reason I see is that the offline mode is not available on your machine. Are you able to manually go offline?

Issue came back again today.

I have tried the suggestion to disable prompt to start in offline mode, close and re-opened the application. Got the error as expected, re-enabled the option to prompt to start in offline mode. Closed and re-opened RDM and there is still no prompt to start in offline mode.

Performing these steps made the normal fix not work properly. The normal steps to connect to VPN and then open RDM didn't fix the issue. I had to go into %localappdata%\Devolutions\RemoteDesktopManager. I had to find a file ending with .SHK. I had to delete the file and the folder that matched the same filename. Once that was done I could reconnect to the SQL source while on VPN.

Not sure what you're trying to ask here. The issue is when the application is starting up for the first time. By definition, this machine will always be "offine" from the SQL source the first time the application starts. The SQL server is unavailable until the VPN connection is started. The VPN connection doesn't get connected until after RDM is started because it is a connection defined within RDM.

The whole point of the option is to prompt to always start in offline mode. Instead, RDM is ignoring that option and trying to connect to the SQL server immediately when started instead of prompting to start in offline mode.

To answer your question, when I'm online I've always been able to go offline manually, that has never been an problem..

Hello,

We're unable to reproduce your issue on the current version of RDM. Could you download and install version 11.6.0.0 and see if the issue happens still? In 11.6.0.0 there is also an option in File > Options > General > Application Start called "Startup online state" and you can set it to automatically go offline. This might be a good workaround if you always connect to that datasource offline first.

Regards,