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
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
Do you use the integrated security with SQL Server?
David Hervieux
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
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
Hi an thanks for the answers.
After update to 9.0.1.0 it works!
Regards Flo