Notification

My Notification alert stop working.
i didn't change anything.
when i send send test email i can see error in the event viwer:

Event Type:      Error
Event Source:      DatabaseMail
Event Category:      None
Event ID:      0
Date:            11/11/2008
Time:            7:07:47 AM
User:            N/A
Computer:      ServerName
Description:
Database Engine Instance=DW1;Mail PID=7080;Error Message:
The update to the database failed. Reason:
The EXECUTE permission was denied on the object 'sysmail_logmailevent_sp', database 'msdb', schema 'dbo'.

Any idea?
yarshwAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicIT ArchitectCommented:
did you make any changes to user rights, since error is stating that you do not have PRIVILEGE to EXECUTE...
0
yarshwAuthor Commented:
No but  am not the only person that workon this server, also DBA working on it, but he say he didn't make any changes.

how can i know which user need permissions?
0
Haris DulicIT ArchitectCommented:
you need to check the permission for the user that is set in the application  DatabaseMail... it can be your user or any user you put to connect to db
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

yarshwAuthor Commented:
I can't see where the how to determine which user should have the rights.
can you be more specific?

Thanks
0
Haris DulicIT ArchitectCommented:
can you check who has privilege to EXECUTE 'sysmail_logmailevent_sp' procedure??

and can you ask DBA to send that test mail... just to check is it ok for his user.
0
mlmccCommented:
What does this have to do with Crystal Reports?

Is this a database alert?
If so which database, I'll adjust the forum list

mlmcc
0
yarshwAuthor Commented:
Hi,

it's sql 2005 server and i am trying to have notification on jobs.
it was working till two weeks and then suddenly stop working.
when i try to send test email from the database mail i got an error.
you can see the error above, in the original question.
looks like permissions issue but i don't sure how to check and fix it.

Thanks.
0
yarshwAuthor Commented:
Ha, my mistake.
should not be in crystal rerport zone.
just SQL.
0
Haris DulicIT ArchitectCommented:
anything related to my post ID:22929849??
0
chapmandewCommented:
make sure whatever user you use to send the noficiations has access to the msdb db and that they can execute the proc sysmail_logmailevent_sp
0
yarshwAuthor Commented:
I changed the services to be run under domain user account instead of local service account and it solved it.

the strange thing is that it work before and i didn't change it.

Thanks.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.