Unable to change user password

Hi Rob,

We support the function to change password, most of the time this error is coming because the user (your admin account) do not have all the rights on Azure SQL. This access is not about being Administrator of RDM but having the "Change Password" option available by your user on Azure.

Could you test with a full admin account of Azure SQL DB please.

Best regards,

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

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.

Your schema is perfect. Could you please try the latest release (v12.6.0.0)?

https://remotedesktopmanager.com/Home/Download

Best regards,

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?

The issue looked familiar so I looked through my recent changes I found a change I made on June 7th. Comment on the change: "Fixed possible issue with password change in SQL Server". We've added the note to the change history (will be live soon).

Best regards,

Hi OP, did you solve the problem? If yes, would you please share more details about the solution? thanks

@Iris Spany,

What version of RDM are you running?

Are you using a SQL Azure data source?

Does your issue is that you are not able to change the database user password?

Best regards,