I can't get email notification to work

I posted this on the Sql Server Notification Services newsgroup, but there's
been no response, and I now see that it doesn't get much use. So here it is
again:
I have been given the job of database administrator. I very good at SQL
programming, but am just learning about things like backups, replication,
etc. and am VERY shaky on anything involving network administration. I am
not the one who installed Sql 2005 database, so I don't know if any steps
were missed.
Email notification does not work, and I don't know if it ever did. I have
to remember to run a CheckJobs script periodically because the system is not
going to tell me if something goes wrong.
I would like to get this working, but I don't know where to start. The
70-431 Training Kit says that Database Mail must be enabled through the SQL
Server Surface Area Configuration tool, but when I open that up, I have no
idea what I'm supposed to do.
I also went through the Database Mail Configuration Wizard; no error
messages but also no messages coming through my email. When I view the
history, I see a lot of failures, but nothing that tells me why.
How do I fix this?
Also, could the failure in email notification be connected to the fact that
I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
fixing one problem will fix both? I was really surprised when I failed in
this simple exercise, since I had no problem setting up a linked server while
working on a client system a couple of years back. I also bombed in my
endpoint exercises, but that's something that's completely new to me.Fire up SQL Server Surface Area Configuration tool and click on Surface Area
Configuration for Features. Find your instance and click on it. Expand
"Database Engine" and go to Database Mail. Enable it and then restart your
SQL Server service using SQL Server Configuration Manager.
Open up SSMS (Management Studio) and connect to your instance. Go to
Management and right click on Database Mail it. Choose Configure Database
Mail.
Set up Database Mail. Create a Profile, and then create an account.
Determine if it's gonna be a public or private profile. Profiles are either
public or private. A private profile is accessible only to specific users or
roles. A public profile allows any user or role with access to the mail host
database (msdb) to send e-mail using that profile.
Right click on Database Mail again and try a test mail.
If it works without any problem, then you can use this notification method
for your jobs or whatever.
P.S.
Ensure the data you enter for account configuration is correct and works
fine.
--
Ekrem Ã?nsoy
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:C00E859A-B110-4FCC-B22A-2F7A69AE732D@.microsoft.com...
>I posted this on the Sql Server Notification Services newsgroup, but
>there's
> been no response, and I now see that it doesn't get much use. So here it
> is
> again:
> I have been given the job of database administrator. I very good at SQL
> programming, but am just learning about things like backups, replication,
> etc. and am VERY shaky on anything involving network administration. I
> am
> not the one who installed Sql 2005 database, so I don't know if any steps
> were missed.
> Email notification does not work, and I don't know if it ever did. I have
> to remember to run a CheckJobs script periodically because the system is
> not
> going to tell me if something goes wrong.
> I would like to get this working, but I don't know where to start. The
> 70-431 Training Kit says that Database Mail must be enabled through the
> SQL
> Server Surface Area Configuration tool, but when I open that up, I have no
> idea what I'm supposed to do.
> I also went through the Database Mail Configuration Wizard; no error
> messages but also no messages coming through my email. When I view the
> history, I see a lot of failures, but nothing that tells me why.
> How do I fix this?
> Also, could the failure in email notification be connected to the fact
> that
> I can't set up a linked server to the Sql 2000 Server on my PC? Like
> maybe
> fixing one problem will fix both? I was really surprised when I failed in
> this simple exercise, since I had no problem setting up a linked server
> while
> working on a client system a couple of years back. I also bombed in my
> endpoint exercises, but that's something that's completely new to me.|||Hi Bev
I assume that you are alerting an operator when the job has completed/failed
etc?
Ekrem has described setting up database, but you description implies that it
has already been configured? Do you get any information in the database mail
log ( right click the database mail node and view the log) ?
It could be that your firewall is not configured correctly, can you ping and
telnet to the smtp relay (I assume that you are not using SQL Mail!).
If database mail is working, you may want to try and create a new operator
and see if they can be emailed notifications.
John
"Bev Kaufman" wrote:
> I posted this on the Sql Server Notification Services newsgroup, but there's
> been no response, and I now see that it doesn't get much use. So here it is
> again:
> I have been given the job of database administrator. I very good at SQL
> programming, but am just learning about things like backups, replication,
> etc. and am VERY shaky on anything involving network administration. I am
> not the one who installed Sql 2005 database, so I don't know if any steps
> were missed.
> Email notification does not work, and I don't know if it ever did. I have
> to remember to run a CheckJobs script periodically because the system is not
> going to tell me if something goes wrong.
> I would like to get this working, but I don't know where to start. The
> 70-431 Training Kit says that Database Mail must be enabled through the SQL
> Server Surface Area Configuration tool, but when I open that up, I have no
> idea what I'm supposed to do.
> I also went through the Database Mail Configuration Wizard; no error
> messages but also no messages coming through my email. When I view the
> history, I see a lot of failures, but nothing that tells me why.
> How do I fix this?
> Also, could the failure in email notification be connected to the fact that
> I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> fixing one problem will fix both? I was really surprised when I failed in
> this simple exercise, since I had no problem setting up a linked server while
> working on a client system a couple of years back. I also bombed in my
> endpoint exercises, but that's something that's completely new to me.|||Since I'm not allowed to make changes during normal working hours, and I
can't stay late tonight, I will tackle these suggestions tomorrow night.
I do not know if the database mail has already been configured. I also
don't know if the problem lies in our firewall, but we've had problems with
it before in terms of it being way too restrictive. There was a time when it
blocked us from accessing even our own website, which put a real crimp in my
job as website administrator.
So, how do I "ping and telnet to the smtp relay?"
"John Bell" wrote:
> Hi Bev
> I assume that you are alerting an operator when the job has completed/failed
> etc?
> Ekrem has described setting up database, but you description implies that it
> has already been configured? Do you get any information in the database mail
> log ( right click the database mail node and view the log) ?
> It could be that your firewall is not configured correctly, can you ping and
> telnet to the smtp relay (I assume that you are not using SQL Mail!).
> If database mail is working, you may want to try and create a new operator
> and see if they can be emailed notifications.
> John
>
> "Bev Kaufman" wrote:
> > I posted this on the Sql Server Notification Services newsgroup, but there's
> > been no response, and I now see that it doesn't get much use. So here it is
> > again:
> >
> > I have been given the job of database administrator. I very good at SQL
> > programming, but am just learning about things like backups, replication,
> > etc. and am VERY shaky on anything involving network administration. I am
> > not the one who installed Sql 2005 database, so I don't know if any steps
> > were missed.
> > Email notification does not work, and I don't know if it ever did. I have
> > to remember to run a CheckJobs script periodically because the system is not
> > going to tell me if something goes wrong.
> > I would like to get this working, but I don't know where to start. The
> > 70-431 Training Kit says that Database Mail must be enabled through the SQL
> > Server Surface Area Configuration tool, but when I open that up, I have no
> > idea what I'm supposed to do.
> > I also went through the Database Mail Configuration Wizard; no error
> > messages but also no messages coming through my email. When I view the
> > history, I see a lot of failures, but nothing that tells me why.
> > How do I fix this?
> > Also, could the failure in email notification be connected to the fact that
> > I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> > fixing one problem will fix both? I was really surprised when I failed in
> > this simple exercise, since I had no problem setting up a linked server while
> > working on a client system a couple of years back. I also bombed in my
> > endpoint exercises, but that's something that's completely new to me.|||Hi Bev
ping and telnet are command line utilities, you can find information about
them in the windows help. Commands such as netstat and nslookup may also be
useful. You may want to get the network and firewall guys to check the logs
whilst you attempt to send mail. You may have to get through more than one
firewall.
As far as database mail configuration goes I suggest you find a test machine
that has not got it configured or a machine you can set up SQL Server on and
go through the actions of configuring it so that you are familiar.
John
"Bev Kaufman" wrote:
> Since I'm not allowed to make changes during normal working hours, and I
> can't stay late tonight, I will tackle these suggestions tomorrow night.
> I do not know if the database mail has already been configured. I also
> don't know if the problem lies in our firewall, but we've had problems with
> it before in terms of it being way too restrictive. There was a time when it
> blocked us from accessing even our own website, which put a real crimp in my
> job as website administrator.
> So, how do I "ping and telnet to the smtp relay?"
> "John Bell" wrote:
> > Hi Bev
> >
> > I assume that you are alerting an operator when the job has completed/failed
> > etc?
> >
> > Ekrem has described setting up database, but you description implies that it
> > has already been configured? Do you get any information in the database mail
> > log ( right click the database mail node and view the log) ?
> >
> > It could be that your firewall is not configured correctly, can you ping and
> > telnet to the smtp relay (I assume that you are not using SQL Mail!).
> >
> > If database mail is working, you may want to try and create a new operator
> > and see if they can be emailed notifications.
> >
> > John
> >
> >
> > "Bev Kaufman" wrote:
> >
> > > I posted this on the Sql Server Notification Services newsgroup, but there's
> > > been no response, and I now see that it doesn't get much use. So here it is
> > > again:
> > >
> > > I have been given the job of database administrator. I very good at SQL
> > > programming, but am just learning about things like backups, replication,
> > > etc. and am VERY shaky on anything involving network administration. I am
> > > not the one who installed Sql 2005 database, so I don't know if any steps
> > > were missed.
> > > Email notification does not work, and I don't know if it ever did. I have
> > > to remember to run a CheckJobs script periodically because the system is not
> > > going to tell me if something goes wrong.
> > > I would like to get this working, but I don't know where to start. The
> > > 70-431 Training Kit says that Database Mail must be enabled through the SQL
> > > Server Surface Area Configuration tool, but when I open that up, I have no
> > > idea what I'm supposed to do.
> > > I also went through the Database Mail Configuration Wizard; no error
> > > messages but also no messages coming through my email. When I view the
> > > history, I see a lot of failures, but nothing that tells me why.
> > > How do I fix this?
> > > Also, could the failure in email notification be connected to the fact that
> > > I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> > > fixing one problem will fix both? I was really surprised when I failed in
> > > this simple exercise, since I had no problem setting up a linked server while
> > > working on a client system a couple of years back. I also bombed in my
> > > endpoint exercises, but that's something that's completely new to me.|||Click Start-Run and enter 'cmd' to get a DOS prompt from the computer you
are trying to send email from.
C: \> ping your.mailserver.com
Did it get through, or did you lose the packets. Did it resolve the IP
address correctly?
Assuming that you're sending email via SMTP and that the mail server is
using the default mail port of 25 ...
C:\> telnet your.mailserver.com 25
A fail looks like:
Connecting To your.mailserver.com...Could not open connection to
the host, on port 25: Connect failed
On success, you will get a message and the cursor will be on the left side
of the creen (no prompt). Enter (I think) HELO and see if you get a
response. If so, you are connected to the mail server.
Jay
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:9C1D3DB5-AB2E-4C81-BAD0-3B9A95739CF9@.microsoft.com...
> Since I'm not allowed to make changes during normal working hours, and I
> can't stay late tonight, I will tackle these suggestions tomorrow night.
> I do not know if the database mail has already been configured. I also
> don't know if the problem lies in our firewall, but we've had problems
> with
> it before in terms of it being way too restrictive. There was a time when
> it
> blocked us from accessing even our own website, which put a real crimp in
> my
> job as website administrator.
> So, how do I "ping and telnet to the smtp relay?"
> "John Bell" wrote:
>> Hi Bev
>> I assume that you are alerting an operator when the job has
>> completed/failed
>> etc?
>> Ekrem has described setting up database, but you description implies that
>> it
>> has already been configured? Do you get any information in the database
>> mail
>> log ( right click the database mail node and view the log) ?
>> It could be that your firewall is not configured correctly, can you ping
>> and
>> telnet to the smtp relay (I assume that you are not using SQL Mail!).
>> If database mail is working, you may want to try and create a new
>> operator
>> and see if they can be emailed notifications.
>> John
>>
>> "Bev Kaufman" wrote:
>> > I posted this on the Sql Server Notification Services newsgroup, but
>> > there's
>> > been no response, and I now see that it doesn't get much use. So here
>> > it is
>> > again:
>> >
>> > I have been given the job of database administrator. I very good at
>> > SQL
>> > programming, but am just learning about things like backups,
>> > replication,
>> > etc. and am VERY shaky on anything involving network administration.
>> > I am
>> > not the one who installed Sql 2005 database, so I don't know if any
>> > steps
>> > were missed.
>> > Email notification does not work, and I don't know if it ever did. I
>> > have
>> > to remember to run a CheckJobs script periodically because the system
>> > is not
>> > going to tell me if something goes wrong.
>> > I would like to get this working, but I don't know where to start. The
>> > 70-431 Training Kit says that Database Mail must be enabled through the
>> > SQL
>> > Server Surface Area Configuration tool, but when I open that up, I have
>> > no
>> > idea what I'm supposed to do.
>> > I also went through the Database Mail Configuration Wizard; no error
>> > messages but also no messages coming through my email. When I view the
>> > history, I see a lot of failures, but nothing that tells me why.
>> > How do I fix this?
>> > Also, could the failure in email notification be connected to the fact
>> > that
>> > I can't set up a linked server to the Sql 2000 Server on my PC? Like
>> > maybe
>> > fixing one problem will fix both? I was really surprised when I failed
>> > in
>> > this simple exercise, since I had no problem setting up a linked server
>> > while
>> > working on a client system a couple of years back. I also bombed in my
>> > endpoint exercises, but that's something that's completely new to me.