Unable to change the password

Unable to change the password

avatar

Hi,
I installed RDM with SQL Express.
If I create a new user it works but if the user want to change his password, the massage "Unable to change the password" occurs.

Do you know the problem?

Regards

Flo

All Comments (5)

avatar

Could you please have a look at the application log (Help -> View Application Log) there should be a detail error message. Please post it here. Thanks

Stéfane Lavergne

avatar

Do you use the integrated security with SQL Server?

David Hervieux

avatar

Hi an thanks for the answers.

No, I'm not using the integrated security.

Sorry for the german log:

-------------------------------------------
[01.10.2013 15:25:37]ERROR System.Data.SqlClient.SqlException: Der Benutzer besitzt nicht die Berechtigung zum Ausführen dieser Aktion.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction, IDbDataParameter[] parameters)
bei Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.AddLogin(String userName, String password, Boolean integratedSecurity, IDbConnection dbConnection, IDbTransaction dbTransaction)
bei Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.DoSaveUserInfo(UserInfo userInfo, Boolean editMode, String password, SaveUserInfoAdvancedCustomData customData, Guid[] userGroupInfos)
****************************** SqlError ******************************
Message:Der Benutzer besitzt nicht die Berechtigung zum Ausführen dieser Aktion.
-------------------------------------------

Where I can change the rights for users I added in RDM?

Regards Flo

avatar

The bug is fixed and will be available in the next release.

We've change the code from sp_password to a simple ALTER LOGIN. It requires no special privileges, from SQL Server help:

A principal can change the password, default language, and default database for its own login.
http://technet.microsoft.com/en-us/library/ms189828.aspx

Stéfane Lavergne

avatar

Hi an thanks for the answers.
After update to 9.0.1.0 it works!

Regards Flo