Unable to load the SQLite datasource. The saved master key is invalid
Unable to load the SQLite datasource. The saved master key is invalid
I upgraded RDM Free to 2022.3.27.0 on a Windows Remote Desktop Server system (Windows 2019) which has been working flawlessly for years. I'm now getting the above error when loading RDM. Has something changed around SQLite in the latest version. 
The connections.db file is stored in the user's home folder on the network:
\\bartax.local\dfs\user\home\username\Documents\Remote Desktop Manager\Connections.db.
I restored a backup of this file and same problem. Interestingly, when I came to create another data source (found an article about a similar problem), I was unable to create a new database in the home folder. Got this error:
However, I was able to create a copy in the %APPDATA%\Devolutions folder (which appears to be the default location).
It's almost as if there is now a problem with SQLite accessing the database when stored on a network folder. One for the developers to comment on maybe.
It's not a showstopper. It's all backed up in the cloud and having it in %APPDATA% is fine.
All Comments (2)
BTW - re the problem creating a database in the network home folder - it did create the file but it was zero bytes long after that error above.
Hello,
Thank you for contacting us on that matter!
We have received similar reports. It seems that even though the Sqlite data source was never meant to be used on a network drive, it worked for some users on older versions of RDM. Since this is not something that was meant to be supported, this won't be something that we will be able to "fix". For more information, please consult this link: https://forum.devolutions.net/topics/38506/sqliteexception-database-disk-image-is-malformed-error#169396
The workaround, as you mentioned, is to either store the connections.db locally, or to opt for the XML data source which can be used on a network drive. Please note that if multiple connections are made to the same XML file, it will eventually lead to the corruption of the data it contains.
Best regards,
James Lafleur