Notification manager tests fail on MSSQL due to the use of identity insert while it's not enabled. MSSQL needs to be handled accordingly in the test to prevent the test failure.