Forum / Devolutions Password Server - Bug Report

SqlException - The INSERT permission was denied on the object 'NotificationEvent'

  • Create an Issue
  • Cancel

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.

Clock17 days

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

signaturesignature

Clock17 days

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

Clock17 days

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

signaturesignature

Clock17 days

Hi David,

This problem has been resolved with the changes on the database.
Regards,
Edwin

Clock14 days

Hi,

Perfect, thanks for the followup.

Regards,



David Grandolfo

signaturesignature

Clock14 days