This just occurred to me: Could the failure in email notification have any
relation 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.
"Bev Kaufman" wrote:
> 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 day.
> 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?