One of our end users' RDM Enterprise hangs before it even loads the data source if it isn't run as administrator.
The problem seems to be the exact same described in this post: https://forum.devolutions.net/topic22428-rdm--enterprise-hangs-unless-started-with-run-as-administrator.aspx
We've tried the suggestions from David in said post (select a local data source and open the application with this selected), and then RDM launches just fine, but the instant the other data source is selected, RDM freezes. We've also tried to open the connection manually using SQL Management Studio with no problems. Permissions shouldn't be the cause, as we have several users with the same permissions as the user in question, and they are not experiencing this problem.
We have tried reinstalling RDM multiple times, to no avail.
Any suggestions?
Could you go in Help->Profiler and switch to the SQL Server data source. Perhaps we will see where it's hang.
David Hervieux
I am unable to see the output in the Profiler, as it also hangs when I switch to the other data source.
Could you reduce the size of the main window and make sure that the profiler dialog is always visible. Make sure to change the debug level and switch to another data source.
David Hervieux
The profiler itself also freezes when the main window does, so even if it is visible on the screen, I am not able to see the output.
Could you verify the Firewall. Perhaps the application is blocked from accessing the database when it's not an administrator?
David Hervieux
Tried disabling the firewall and then launching RDM, but it still freezes before it loads anything.
Could you try with the latest version? you can unzip it in another folder.
David Hervieux
Unfortunately that is not an option for me, as our database would need to be upgraded in order to be compatible with the latest version, which we cannot do at the time being.
Is it possible to create another database with no content and just for a test?
David Hervieux
I just tried signing in to the user's AD account on another computer, and then it works just fine, so it seems to be a problem with his installation. I uninstalled RDM and deleted the Devolutions folder from %localappdata% and then reinstalled. However, when I create the data source, the application freezes as soon as I either click to browse for databases or click Test Server.
How can I make sure everything (settings etc.) is removed before reinstalling?
You seems to have deleted everything. Could you try to install it somewhere else than program files. For example in C:\RDM
Regards
David Hervieux
Installed to C:\RDM, same thing still happens.
Could you try remotedesktopmanager64.exe instead?
David Hervieux
Sorry, forgot to mention that in my previous post - I did try running the 64-bit version as well, but it also freezes.
Could you please try to delete all your offline.db files in %localappdata%\Devolutions[sub folders] to see if that helps?
Stéfane Lavergne
I already tried deleting the entire Devolutions folder from %localappdata% before reinstalling, yet the problem still occurs.
The only thing I can see now is the Anti-Virus. Do you know if the application is whitelisted? Is it the same Anti-Virus on all your machines?
David Hervieux
We run the same AV on all of our machines, and RDM runs just fine on all of them except this one, so I don't suspect the antivirus is the cause. I have previously checked the logs of the antivirus after running RDM, but I didn't find anything relevant.
I just tried to delete his userprofile from his local machine, but RDM still freezes if it isn't run as administrator.
I've just disabled waitprogress.exe (it was not allowed to run due to an AppLocker policy) and moved the status message to the statusbar, which displays the following when RDM is frozen:
Loading sessions from datasource ***
Does this tell you anything?
Could you try to execute the appliation with the /profiler switch to get the details?
David Hervieux
This is the only output I'm able to get from the profiler before it also freezes:
It seems that the application freeze when it tries to access the database
David Hervieux
So what might be causing this? And why does it work just fine when running the application as administrator?
I'm not sure but maybe a system policy.
David Hervieux
We eventually chose to format the machine and do a fresh install of Windows 10, which has fixed the problem.
Thank you for your time and help.
Thank you for the information. I'm sorry we hadn't been able to help you with this. Let me know if you find anything that could explain the problem.
Regards
David Hervieux