SchneeBaer

Hi Jeff!

I was just going to get a fresh start. The one mentioned above are new credentials that aren't in my old database.

Am I doing something wrong with the entry? Or did I not setup my local data source correctly?

Cindy

I've been using an old version of RDM (Version 12.6.8.0 - from end of 2017). I'm migrating to a new computer and thought it would be a good time to upgrade. I'm a consultant and use various VPNs with RDP connections.

In my old version I had the option to store passwords in the database, which was the default Local Data Source. With the current version, I'm having difficulty figuring out how to get the password to populate. I've got a Windows VPN configured, which is working great. I use the same credentials for the RDP. I've tried putting the password in the Password field (immediately below the domain), and while the password appears to save, I am prompted that my credentials did not work, and have to manually enter my password. I've tried ticking the 'Store password locally' box which then makes the password read-only, and I just don't get the Save Password button at all.

Can someone point me in the right direction on how to get this to work?

Okay - that explains why I couldn't find a button/drop-down. Notepad didn't work either.

Maybe it is the client connection. I'll test with a normal RDP session and with other client connections.

Thanks!

I know I'm missing something simple - but how can I copy to the clipboard in a remote session and then pull the clipboard to my local machine and paste?

I have the checkbox marked under Local Resources to use the Clipboard in my remote session.

I'm trying to copy the results grid of a SQL query to a local Excel sheet.

Did some goggling, and ended up uninstalling the Sonicwall VPN client off my machine. Problem solved.

After I connect to a client, and work a little (a dozen clicks at the most), I'm getting the following error: "Because of an error in data encryption, this session will end. Please try connecting to the remote computer again." It then throws me out.

This is a Cisco VPN client connection, and I have the VPN settings in the same session setup as the Microsoft RDP.

I think I figured this one out.

I changed my IE Mode from default to IE 11 (File | Options | Types: Web)

I can successfully make a connection to the Office 365 site - but am missing the top bar once I connect (displays user with various buttons)

How can I get this to display?

LOL. Do I get to ask 'why'?

I swear I had this working before my machine got trashed and I had to reinstall everything.

Okay - I picked my VPN from the drop down and entered 'a' for the remaining 3 fields and it made the connection.

edited by SchneeBaer on 5/7/2014

edited by SchneeBaer on 5/7/2014

One of our clients provided us with 3 certificates and a PBK entry. I've got everything setup so that if I directly click this PBK entry, I get a connection to their VPN without needing to enter any credentials. However, when I enter the PBK file on the VPN tab in RDM either in the Phone Book or Embedded Phone Book, when I launch, I am getting prompted for credentials (which I don't know).

I'm not that familiar with certificates and PBK files. Am I adding this to RDM correctly? Is there a way to get the credentials out of a PBK file?

Just wanted to share a quick update. I was hit by the CryptoWall malware. Apparently it saw the .DB file as a good target.

Slowly recovering...

Okay thanks.

I'm throwing in the towel and starting over.

Lesson learned the hard way on the backup. :(

Do I need to have Microsoft SQL Server loaded locally to use a SQL data source? That would be my preference. We use SQL in-house for several apps, but I do not have the engine loaded locally.

edited by SchneeBaer on 5/1/2014

I also tried to export the data source and then import it. No impact.

When I choose to create a new data source, the SQLite is only available for the standard edition. I purchased the Enterprise. What is the recommended format? This is a machine on a network, but I'm the only one using RDM. Whatever the type, I will be backing it up via Carbonite to the cloud.

Regarding the password, I don't remember if I put a password on the data source. If I did, I know what it would be. However, when I go to File | Data Sources, the 'secure with password' checkbox is not marked.

If I edit the connection, mark the checkbox, enter a password and mark to always ask, and click the OKs, I am prompted for a password and then told the password is invalid.

Would a Windows system restore bring this file back?

Went thru the steps with the sqlite, but when I ran the integrity check, I got the same error: file is encrypted or is not a database

I'm not clear on what you mean by 'recreated the data source configuration' (which probably means that I didn't).

If I delete the connections.db, will that create a new one for me to start over? That will be immensely painful, but will at least get me progressing down a forward moving path.

I was working in RDM yesterday without a problem, but today, I am getting the message: “file is encrypted or is not a database” when I launch. None of my connections are showing in the left bar.

I’m on version 9.1.0.0 (not current) on a Windows 7 64-bit OS. The last thing I was doing yesterday was trying to connect to a client that has an old Cisco VPN (5.0.07.0240), and I couldn’t get the VPN to work. I ran the Repair on the Cisco install via Control Panel | Programs.

I have a lot of clients setup, and am severely crippled without RDM, and am concerned that I did not make an effort to ensure this data file was getting backed up. I'm hoping I can recover this data.

From the Application Log:

[3/12/2014 9:03:01 PM]INFO Windows shutdown occurring, closing application.

[4/21/2014 2:21:02 PM]INFO Windows shutdown occurring, closing application.

[5/1/2014 9:37:53 AM - 9.1.0.0]ERROR System.Data.SQLite.SQLiteException: file is encrypted or is not a database

file is encrypted or is not a database

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ReadConnections(IDbCommand dbCommand, List`1& result, Byte[]& cacheVersion, Int32& deleteCount)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetConnections()

at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(BaseConnectionDataSource connectionDataSource)

[5/1/2014 9:38:29 AM - 9.1.0.0]ERROR System.Data.SQLite.SQLiteException: file is encrypted or is not a database

file is encrypted or is not a database

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ReadConnections(IDbCommand dbCommand, List`1& result, Byte[]& cacheVersion, Int32& deleteCount)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetConnections()

at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(BaseConnectionDataSource connectionDataSource)

[5/1/2014 9:39:51 AM - 9.1.0.0]ERROR System.Data.SQLite.SQLiteException: file is encrypted or is not a database

file is encrypted or is not a database

at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)

at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)

at System.Data.SQLite.SQLiteDataReader.NextResult()

at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)

at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ReadConnections(IDbCommand dbCommand, List`1& result, Byte[]& cacheVersion, Int32& deleteCount)

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.GetConnections()

at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(BaseConnectionDataSource connectionDataSource)

edited by SchneeBaer on 5/1/2014

edited by SchneeBaer on 5/1/2014

Sorry - kind of new with this tool. I only have one session. I have the Remote Desktop info on the Connection tab, the VPN info on the VPN tab and these command lines on the Events tab.

Does that answer your question at all?

Interestingly enough, when I disconnected from the client, the stop service command worked! I tried increasing the post execution pause on the 'Before Connect' command line, but the VPN is not waiting.

Adding a 10 second pause after the command line did not help. :)

I don't keep all my remote services running - especially Cisco. Before RDM I manually started the Cisco service, connected to the VPN and then connected using Remote Desktop. I've got everything working except the starting and stopping of the service.

I have verified a command prompt line that will start and stop the service, and have it entered on the Events tab. However, this command line does not appear to be running before the VPN connection.

My command line: c:\windows\system32\net start CVPND

Any thoughts?

I'm still in my first 30 days with this amazing product, and am overwhelmed by the manual. This product looks so robust, I'm sure there is a way to launch another remote desktop session from within the session I've just initiated with Remote Desktop Manager.

Can anyone give a newbie a point in the right direction?