sql mail not notifying

Question

sql mail not notifying

bluepaperbag

SSCrazy

Points: 2055
More actions
January 22, 2008 at 2:01 pm

#71347

sql mail is not notifying me when a job fails. Anyone know how to troubleshoot it?
Looks like the mail icon in control panel is missing. could that be the problem? How do you get it back?
windows 2003
ss2000

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

You need the outlook client with a profile set up that can actually send and receive mail. Is that set up at this point? Sounds like you might need to start there...

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

I'd highly recommend staying away from SQLMail in SQL2000 ... it's a nightmare.

Instead, there is an easy solution ... upgrade to 2005 and use database mail! 🙂 If that's possible, use cdosysmail: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50879

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

I used SQL Mail at my last employer. We had to install Outlook on the server and setup a mail profile. For the most part, it was reliable. we did have a few occasions where we had to restart SQL because mail hung, but that was fairly infrequent.

If you can upgrade to SQL Server 2005, using Database Mail is much easier.

😎

bluepaperbag SSCrazy Points: 2055 More actions · Answer 4

Adam Bean (1/23/2008)

I'd highly recommend staying away from SQLMail in SQL2000 ... it's a nightmare.

Instead, there is an easy solution ... upgrade to 2005 and use database mail! 🙂 If that's possible, use cdosysmail: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50879%5B/quote%5D

upgrade to 2k5?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Yes, you may want to look at upgrading from SQL Server 2000 to SQL Server 2005 (maybe even SQL Server 2008 as it comes out this year).

Standard suport for SQL Server 2000 ends (I believe) in March or April of this year. After that, all you will get (unless you are paying for support) are security hot fixes.

😎

bluepaperbag SSCrazy Points: 2055 More actions · Answer 6

I have a 2k5 server but the mail is not notifying too.

bluepaperbag SSCrazy Points: 2055 More actions · Answer 7

My SQL Server agent is using the account "ibrowse\sqladmin". anyone know where is this account stored and how could i find out the password?

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 8

Hello,

Is "ibrowse" the domain name??

If it is a domain name then it will be present in your Active Directory (machine) database. Normally, system admins set such type of service accounts without password expiration so it overrides the default policy of changing the password for every 30 days.

Hope this helps.

Thanks

Lucky

bluepaperbag SSCrazy Points: 2055 More actions · Answer 9

Lucky,

I think you are wrong when you say this account doesn't use password. Well I went to services deleted the password and tried to start the service. But it didnt as it's telling me logon failure.

bluepaperbag SSCrazy Points: 2055 More actions · Answer 10

I have clicked on the test button under operator. It says Successfully sent. But I never got the email. Any ideas?

Tom Hegh SSC Enthusiast Points: 135 More actions · Answer 11

Hello,

I have a SQL Server 2000 running on Windows Server 2003.

In order to use eg a DTS package that will send a status mail including job statusses etcetera it's important to keep in mind that you must have an account set up that actually exists on the domain, and also has the necessary rights to send a mail.

When this is ok, you'll see that it will work quite nice.

Regards,

Tom

bluepaperbag SSCrazy Points: 2055 More actions · Answer 12

Tom Hegh (2/6/2008)
Hello,
I have a SQL Server 2000 running on Windows Server 2003.
In order to use eg a DTS package that will send a status mail including job statusses etcetera it's important to keep in mind that you must have an account set up that actually exists on the domain, and also has the necessary rights to send a mail.
When this is ok, you'll see that it will work quite nice.
Regards,
Tom

Tom,

I do have an account in the domain that is able to send email. I have login to the server with this account, created a mail profile and used Outlook to send out a test mail to myself.

However If I go under operators on EM and click on test. It says sent successfully. But I never got the email.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 13

Here is a KB for setting up mail and a few issues:

http://www.sqlservercentral.com/articles/Administering/sqlmailresources/605/

Walk through the procedure from MS exactly.

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 14

You have to have ur sql server services running with the account that you are going to use for mail profile. then configure your mail profile and then add the profile to sql server mail so that there will be no issues remember to restart sql servces to take effect.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com