Notify Operator Task not showing operators

Posted on 2007-08-08
Last Modified: 2013-11-05
In SQL 2005, I've created an operator on the server, but when I drag a "Notify Operator Task" tool onto design view and attempt to configure it, I receive an error message saying:

"There are no operators with email addresses defined on this server"

Clearly there are. I've also tried creating a new connection to the server.  What could be causing this?

Question by:barnesco
    LVL 3

    Accepted Solution

    Have you installed and configured SQLiMail?  It's a new tool that doesn't use Outlook to send emails.
    LVL 35

    Expert Comment

    by:David Todd

    Do you mean DatabaseMail?

    LVL 3

    Expert Comment

    Oh yeah, that's it, I think SQLiMail was the name for the beta. :)  DatabaseMail is the new name

    Author Comment

    Yes, database mail has been set up and all patches have been updated.

    Expert Comment

    Hi there -- I have the EXACT same problem .. and have done what barnesco states here myself (i..e set up database mail .. ) .. but STILL problem persists.  I note the "accepted solution" is to set up database mail .. but that's not it .. not just it in other words.  What else can we try?  Barnesco -- did you finally solve this ?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    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…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now