SqlException - The INSERT permission was denied on the object 'NotificationEvent'
SqlException - The INSERT permission was denied on the object 'NotificationEvent'
After upgrading to dps server 2019.2.12.0 we get a lot of SqlExceptions.
SqlException - The INSERT permission was denied on the object 'NotificationEvent', database 'Devolutions', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.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, Boolean shouldCacheForAlwaysEncrypted)
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.Server.DatabaseManager.ExecuteNonQuery(String sql, IEnumerable`1 parameters, CommandType commandType)
at Devolutions.Server.DatabaseManager.ExecuteNonQuery(String sql, DbTransaction dbTransaction, IEnumerable`1 parameters, CommandType commandType)
at Devolutions.Server.Business.NotificationV2.NotificationEventManager.cbe516c6bdb82ab59ccdeefa940bbcdcc(NotificationEvent cabf3cb872682a1788297f3e80abdb2a3, PamBaseAdapter c511ec9a074fa21e3e8bb23cb6a7141a2)
at Devolutions.Server.Business.NotificationV2.NotificationEventManager.c97ad4180156a1eb36445e18a8605b2fb(NotificationEvent cabf3cb872682a1788297f3e80abdb2a3, PamBaseAdapter c511ec9a074fa21e3e8bb23cb6a7141a2)
RDM version makes no difference... We have updated rdm to 2109.2.24.0 but still the errors remain.
All Comments (5)
Hello,
Have you configured the Integrated Security on DPS? If yes, could you please run the following SQL Statement? Please replace the user WINDJAMMER\VaultRunner with the proper username.GRANT INSERT, UPDATE ON dbo.NotificationEvent to [WINDJAMMER\VaultRunner];GRANT INSERT, UPDATE, DELETE ON dbo.NotificationSubscription to [WINDJAMMER\VaultRunner];
If you have other errors after these commands please let us know and I will send you the full upgrade script.
Best regards,
David Grandolfo
Hi David,
Yes we are running integrated security.
I've multiple users who are generating these errors. Do i need to run this script for every user?
Regards,
Edwin
Hi,
No the user reference in this SQL query is the user configured in the DPS console.
I'm referring if Integrated security is checked at step 6 https://helpserver.devolutions.net/install_createrdmsinstance.htm
If so, the user name can be found in IIs Applications pools more detail at https://helpserver.devolutions.net/configure_integratedsecurity.htm
Regards,
David Grandolfo
Hi David,
This problem has been resolved with the changes on the database.
Regards,
Edwin
Hi,
Perfect, thanks for the followup.
Regards,
David Grandolfo