Unable to create user or change role

Unable to create user or change role

avatar

Hi,

I got an error when i try to create a new user.

I'm administrator.

All Comments (16)

avatar

Hello,

What version of RDM are you running?

What type of data source are you using?

Maurice

avatar

11.0.19.0

and

MSSQL

avatar

see log

[2016-01-22 11:10:12 - 11.0.19.0]ERROR System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'drop'.

Unknown object type 'member' used in a CREATE, DROP, or ALTER statement.

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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

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

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.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction)

at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.c65987261992690f0b3afdd4334c0310f(UserEntity cf98b881282579a38f0d3820b4755fa4a, IDbTransaction c5a0ca8eaa594113c2f0b3cfe13dedff9)

at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerSecuritySubDataSource.c420570cc362838b38ecc18ba825950e5(UserEntity cf98b881282579a38f0d3820b4755fa4a, Boolean cd589fb599494638c495afc5cf9b2449e, String ceb81d1ee93f91e0bc57f34876c263863, SaveUserInfoAdvancedCustomData ca846991ced5070300e1c8ec384f436f9, Guid[] cf090f8a8f0907c3009c224a9172cab64)

ClientConnectionId:b85c543b-c896-4824-9c62-0c3ff0267bee

Error Number:156,State:1,Class:15

****************************** SqlError ******************************

Message:Incorrect syntax near the keyword 'drop'.

****************************** SqlError ******************************

Message:Unknown object type 'member' used in a CREATE, DROP, or ALTER statement.

avatar

Hello,

Is this an issue that started occurring after an update or you are setting up a new system?

Maurice