Unable to login

Hi,
The latest version contains some security fixes for SQL Server. Can you try to connect with a user with the sysadmin right on the SQL Server (sa) ? There is a database upgrade requiring the sysadmin permission. After that, open your user security and set the security settings for your previous user.

Let me know if I can help.

David Hervieux
Devolutions inc.
edited by dhervieux on 9/28/2009

Also, if you can give me the application log, last error with the call stack, it might help.

David Hervieux
Devolutions inc.

Hi David,

I logged in with the SA and modified one thing on one user and it solved all the issues, for all users!

Thanks again!

Good,
Can you post me the call stack from applicaton log, I think that it was related to the database upgrade but I just want to be sure. I will add a better message if it's the case.

Thank you and sorry about that.

David Hervieux
Devolutions inc.

These are the errors from this afternoon (second attempt):

Info[28-9-2009 14:57] Upgrading database for data source 'RDM_3WT_SW' with version 5
ERROR[28-9-2009 14:57] System.Data.OleDb.OleDbException: Cannot find the object "DatabaseInfo" because it does not exist or you do not have permissions.
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String aSQL, OleDbTransaction aOleDbTransaction, OleDbParameter[] aParameters)
at Devolutions.RemoteDesktopManager.Managers.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource aDataSource)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDatabase(BaseConnectionDataSource aConnectionDataSource)
Info[28-9-2009 14:58] Upgrading database for data source 'RDM_3WT_SA' with version 5
Info[28-9-2009 14:58] Upgrading database for data source 'RDM_3WT_SW' with version 5
ERROR[28-9-2009 14:58] System.Data.OleDb.OleDbException: Column names in each table must be unique. Column name 'Settings' in table 'DatabaseInfo' is specified more than once.
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String aSQL, OleDbTransaction aOleDbTransaction, OleDbParameter[] aParameters)
at Devolutions.RemoteDesktopManager.Managers.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource aDataSource)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDatabase(BaseConnectionDataSource aConnectionDataSource)
Info[28-9-2009 14:58] Upgrading database for data source 'RDM_3WT_SA' with version 5
ERROR[28-9-2009 14:58] System.Data.OleDb.OleDbException: Column names in each table must be unique. Column name 'Settings' in table 'DatabaseInfo' is specified more than once.
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String aSQL, OleDbTransaction aOleDbTransaction, OleDbParameter[] aParameters)
at Devolutions.RemoteDesktopManager.Managers.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource aDataSource)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDatabase(BaseConnectionDataSource aConnectionDataSource)