again, no matter what the REAL ERROR is inside the trigger (ie Invalid object name 'DatabaseLogonAudit.dbo.AuditDatabase '. or user does not have access,
the generic error message is all they get.
pretty sure the issue is permissions on the table DatabaseLogonAudit.dbo.AuditDatabase
that's probably a database created by a sysadmin with no users in it at all..hence the trigger fails for anyone not a sysadmin (like when you test it yourself in SSMS..our an admin!)
its super easy to test this yourself, with SSMS:
create a brand new login,and use SSMS to login with it
create login ClarkKent with password = 'NotARealpassword'
that login will fail with the generic error message.
if you look in the SQL log, however, you will see something like this:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!