robm82

Is it possible to update the app to use the Apple Enterprise SSO so that it can call the Azure AD SSO plug-in that is part of Company Portal? https://learn.microsoft.com/en-us/azure/active-directory/develop/apple-sso-plugin

Thanks Stefane - that's seems to have fixed my issue. Although I saw that there really isn't anything in the release notes about this particular issue? What could have been causing this issue do you think?

Ok, we are getting somewhere.

Could you please send me your database schema. File -> Data Sources -> Upgrade (tab) -> Email Schema to Support. Please add "att: Stefane" to the message body. I will analyse the output and should be able to figure out what the underlying issue.

Best regards,

Thanks Stefane - I have sent you on the schema as requested. If you need any further information, please feel free to ask.

Hi,

SQL Azure has some pretty strict password policies.

Can you please try the following?

- File -> Options -> Advanced -> Debug level (set it to 1)

- try changing the password

- Look at the RDM logs (Help -> View Application Log), you should see a message like "Password validation failed. The password does not meet policy requirements because..." or something similar.

- set the Debug level back to 0

If you got a different error please post it here for further analysis.

More information here SQL Azure password policy : https://docs.microsoft.com/en-us/sql/relational-databases/security/strong-passwords

I will add a feature request to notify the admin of password policy issues instead of the generic "Unable to change the password!"

Best regards,

Hi Stefane,

I set the Debug level to 1, and tried again and got a message about an invalid object name 'dbo.UserAccount':

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.UserAccount'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction, IDbDataParameter[] parameters, Int32 commandTimeout)

at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.ResetPassword(UserEntity user, String newPassword)

ClientConnectionId:24669355-99f6-40e5-a207-19b16cfdb3a7

Error Number:208,State:1,Class:16

Hi,

We currently use RDM with an Azure SQL DB, and for some reason we cannot change users passwords if they forget them from the User Administrator screen. It always just displays a box saying "Unable to change the user password!". I am a full administrator, so I should be able to change the password I would have thought?

Is there a way to resolve this so that I can change people's passwords without deleting the user and recreating?

Many thanks.