ASG-RD 2019 Patch 2 - Crash now SQL errors

[DevOma]

You are in the Administrators group - so you should be able to set all values - can you give an example on which folder/connection do you see that problem? Still try to find out what data is causing the problems - if something can't be read correctly that must be the initial error that causes the SQL errors...

[ICTSystemsAdministration]

You are in the Administrators group - so you should be able to set all values - can you give an example on which folder/connection do you see that problem? Still try to find out what data is causing the problems - if something can't be read correctly that must be the initial error that causes the SQL errors...

My account is part of the "Systems Administrators" security group which is when it didn't work. I added my account specifically to the "Administrators" security group and then it started working. I tried setting passwords on multiple connections and folders throughout the tree and the options was grayed out until I added myself to "Administrators"

[DevOma]

The second security group has disabled "Change of personal creds" - so that's like it is configured in your database - enable this option for the second group and you should be able to set personal creds again :-)

I will test it again with assigning the user to "System Administrators"

[ICTSystemsAdministration]

The second security group has disabled "Change of personal creds" - so that's like it is configured in your database - enable this option for the second group and you should be able to set personal creds again :-)

I will test it again with assigning the user to "System Administrators"

Hi Oliver,

  I would if there was a menu option for it, as that's the first thing I checked. If I click the "Systems Administrators" group in "Security Groups" and click the Details... button, every option available is ticked. I've compared the list of options to the "Administrators" group and they are identical.

  If the options for personal creds is somewhere else, please advise.

Thanks
Michael

[DevOma]

On object level - I think it's set somewhere on a root folder - select the group in Permissions and you will see

[ICTSystemsAdministration]

On object level - I think it's set somewhere on a root folder - select the group in Permissions and you will see

I was on about the tick box to allow a certain security group to use personal credentials. In ASG using the below paths, I can't see a specific security attribute that will allow/disallow a user/group to use personal credentials. The list of options is identical and all of them are ticked.

Tools Menu -> Security Groups... -> Administrators -> Details... button
Tools Menu -> Security Groups... -> System Administrators -> Details... button

BUT, if a user is a member of "Administrators" on the above path, they can use personal credentials. If the user is a member of "System Administrators" they cannot use personal credentials.

If it would be easier to show you all this, let me know and i'll share my screen.

Regards
Michael

[ICTSystemsAdministration]

You can rename the profile.xml file in your AppData\Roaming\ASG-RemoteDesktop\12.0 directory - it will be created a new one when starting again

If you can login you can deactivate options for automated reconnect at startup and delete your layout settings (Tools=>Reset Layout)

But I'm wondering why I don't get the same error - I updated your userID with my account - so I log in with the same settings like you...

I removed the app again. Delete any entries for ASG under my current user registry hive, deleted the AppData\Roaming\ASG-RemoteDesktop folder completely, then reinstalled it. I then ran it, connected using the environment which was still configured, then did a Tools -> Reset Layout. Same problem.

I then went through and disabled every option which may save a log file/session etc. and enabled them one-by-one and the error came back when the "Restore sessions on program start without prompt" is ticked (This has always been ticked before the crash). If I un-tick this, it saves my sessions and when I reload it asks me if I want to reconnect. If I click yes, it loads the sessions up without error. As soon as I tick this box, it gives me the SQL errors when I reload the app.

I've also noticed that I am unable to set "Personal Values" on the credential tab for folders/connections (The drop downs are grayed out). I can change the Default Values without issue. I do have working personal credentials configured as I can right click a connection and select them from the options list.

Regards
Michael

I've fixed the "Personal Values" issue by adding my account into the "Administrators" security group, rather than the AD group we have added in with all the options selected. Is this a change in this version or just another bit of weirdness caused by my crash, as this was working before?

Regards
Michael

Can I have an update on this please?

Thanks
Michael

[DevOma]

As I said before - it's on object level - select an object like folder, connection or something else - open Properties dialog and select "Permissions" - there you find all the options that you can set on object level - on Tools=>Security Groups you only find some global permissions… Please have a look

[ICTSystemsAdministration]

As I said before - it's on object level - select an object like folder, connection or something else - open Properties dialog and select "Permissions" - there you find all the options that you can set on object level - on Tools=>Security Groups you only find some global permissions… Please have a look

Yes, I know how the permissions work and as stated, if I go onto an object then the "Personal Values" options are greyed out unless I add my account into the "Administrators" security group.

My main problem though is the reason I logged this thread. After the crash, if I have the auto reconnect to sessions set, I get SQL errors. If I set it to ask me to reconnect, it works fine. I know it's not much of a big deal to click a button, but this points to a corruption somewhere which I need sorting.

Thanks
Michael

[DevOma]

Ok - the option to set personal values should be available if the security options are enabled

Set assigned credentials - allows the user to switch between "Default / Inherited / Personal"
If option "Edit Private data" is not enabled you can allow to set personal credentials only by adding the security option "Edit assigned personal credentials"

That should solve your problem regarding the security settings!


Next one is your problem at startup - it's really curious because the option to be asked to reconnect is really only one more line of code that is executed - show the MessageBox and continue only if Yes was clicked - I will check and think again about that - but it's really curious

[ICTSystemsAdministration]

Ok - the option to set personal values should be available if the security options are enabled

Set assigned credentials - allows the user to switch between "Default / Inherited / Personal"
If option "Edit Private data" is not enabled you can allow to set personal credentials only by adding the security option "Edit assigned personal credentials"

That should solve your problem regarding the security settings!


Next one is your problem at startup - it's really curious because the option to be asked to reconnect is really only one more line of code that is executed - show the MessageBox and continue only if Yes was clicked - I will check and think again about that - but it's really curious

Hi Oliver,

  I found the option by Right Clicking the Connections tree item and did see this wasn't ticked, so I've now ticked that. Thanks for your help on that.

  If we can fix the other one, i'll be a happy user

Thanks
Michael

[ICTSystemsAdministration]

Ok - the option to set personal values should be available if the security options are enabled

Set assigned credentials - allows the user to switch between "Default / Inherited / Personal"
If option "Edit Private data" is not enabled you can allow to set personal credentials only by adding the security option "Edit assigned personal credentials"

That should solve your problem regarding the security settings!


Next one is your problem at startup - it's really curious because the option to be asked to reconnect is really only one more line of code that is executed - show the MessageBox and continue only if Yes was clicked - I will check and think again about that - but it's really curious

Hi Oliver,

  I found the option by Right Clicking the Connections tree item and did see this wasn't ticked, so I've now ticked that. Thanks for your help on that.

  If we can fix the other one, i'll be a happy user

Thanks
Michael

Any update on how to fix the SQL errors? I have noticed that without any disconnected connections, I get prompted to restore 1 connection when I start the program. If I say Yes or No, it just goes in fine without doing anything and the next time I run it, I don't get the prompt. On another quit and run without any saved sessions, I get the prompt again.

Thanks
Michael