?
Solved

Notification

Posted on 2008-11-10
12
Medium Priority
?
1,174 Views
Last Modified: 2012-05-05
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?
0
Comment
Question by:yarshw
11 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 22928442
did you make any changes to user rights, since error is stating that you do not have PRIVILEGE to EXECUTE...
0
 

Author Comment

by:yarshw
ID: 22928494
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
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 22928559
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 

Author Comment

by:yarshw
ID: 22928612
I can't see where the how to determine which user should have the rights.
can you be more specific?

Thanks
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 22929849
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 22933641
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
 

Author Comment

by:yarshw
ID: 22937287
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
 

Author Comment

by:yarshw
ID: 22937299
Ha, my mistake.
should not be in crystal rerport zone.
just SQL.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 22937631
anything related to my post ID:22929849??
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 400 total points
ID: 22944693
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
 

Accepted Solution

by:
yarshw earned 0 total points
ID: 22970357
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question