Questions on 2005 DBMail.  
Author Message
TraumaMedic1





PostPosted: Sun Jun 18 18:31:01 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail.

Howdy all. For the record, I will never again wait this long to start
learning about new versions of SQL Server, there is just too much. With that
out of the way, I'm having issues/ misunderstandings about DB mail.

1; I just logged into my work and set up DBMail on my PC as we have an SMTP
server there that I use all the time. I set it up, but was never asked to
supply the name of my SMTP server. I sent out a test email, expecting it to
fail, but it didn't. I know SQL Server is not magic, but how can it be? How
can it know what SMTP server to use?

2; I set up a simple test job to verify that I would be emailed on failure.
I specified it to use the same account from number 1 above as the Operator.
However, when I ran my job that failed, I never got my email. What gives?

TIA, ChrisR

SQL Server257  
 
 
bnevarez





PostPosted: Sun Jun 18 18:31:01 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail.
Hmmm, interesting. Run

exec msdb.dbo.sysmail_help_account_sp

and inspect the servertype, servername and port values.

Ben Nevarez, MCDBA, OCP
Database Administrator




> Howdy all. For the record, I will never again wait this long to start
> learning about new versions of SQL Server, there is just too much. With that
> out of the way, I'm having issues/ misunderstandings about DB mail.
>
> 1; I just logged into my work and set up DBMail on my PC as we have an SMTP
> server there that I use all the time. I set it up, but was never asked to
> supply the name of my SMTP server. I sent out a test email, expecting it to
> fail, but it didn't. I know SQL Server is not magic, but how can it be? How
> can it know what SMTP server to use?
>
> 2; I set up a simple test job to verify that I would be emailed on failure.
> I specified it to use the same account from number 1 above as the Operator.
> However, when I ran my job that failed, I never got my email. What gives?
>
> TIA, ChrisR
>
>
>
 
 
ChrisR





PostPosted: Sun Jun 18 21:42:31 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail. It has the expected SMTP server, but how did it get that info if I never
specified it? Does 2005 scan the network looking for SMTP servers? Any idea
about number 2?



>
> Hmmm, interesting. Run
>
> exec msdb.dbo.sysmail_help_account_sp
>
> and inspect the servertype, servername and port values.
>
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
>

>
> > Howdy all. For the record, I will never again wait this long to start
> > learning about new versions of SQL Server, there is just too much. With
that
> > out of the way, I'm having issues/ misunderstandings about DB mail.
> >
> > 1; I just logged into my work and set up DBMail on my PC as we have an
SMTP
> > server there that I use all the time. I set it up, but was never asked
to
> > supply the name of my SMTP server. I sent out a test email, expecting it
to
> > fail, but it didn't. I know SQL Server is not magic, but how can it be?
How
> > can it know what SMTP server to use?
> >
> > 2; I set up a simple test job to verify that I would be emailed on
failure.
> > I specified it to use the same account from number 1 above as the
Operator.
> > However, when I ran my job that failed, I never got my email. What
gives?
> >
> > TIA, ChrisR
> >
> >
> >


 
 
bnevarez





PostPosted: Sun Jun 18 23:15:01 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail.
Did you went to SQL Server Agent Properties, Alert System and Enable mail
profile to enable your mail system and mail profile?

You are using 32-bit software, right?

Ben Nevarez, MCDBA, OCP
Database Administrator




> It has the expected SMTP server, but how did it get that info if I never
> specified it? Does 2005 scan the network looking for SMTP servers? Any idea
> about number 2?
>


> >
> > Hmmm, interesting. Run
> >
> > exec msdb.dbo.sysmail_help_account_sp
> >
> > and inspect the servertype, servername and port values.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >

> >
> > > Howdy all. For the record, I will never again wait this long to start
> > > learning about new versions of SQL Server, there is just too much. With
> that
> > > out of the way, I'm having issues/ misunderstandings about DB mail.
> > >
> > > 1; I just logged into my work and set up DBMail on my PC as we have an
> SMTP
> > > server there that I use all the time. I set it up, but was never asked
> to
> > > supply the name of my SMTP server. I sent out a test email, expecting it
> to
> > > fail, but it didn't. I know SQL Server is not magic, but how can it be?
> How
> > > can it know what SMTP server to use?
> > >
> > > 2; I set up a simple test job to verify that I would be emailed on
> failure.
> > > I specified it to use the same account from number 1 above as the
> Operator.
> > > However, when I ran my job that failed, I never got my email. What
> gives?
> > >
> > > TIA, ChrisR
> > >
> > >
> > >
>
>
>
 
 
bnevarez





PostPosted: Sun Jun 18 23:20:02 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail.
I tested the New Account screen on the Database Mail Configuration Wizard
and you can not configure the new account without specifying a server Name.
The Next button is disabled until you type something on Server name.

Ben Nevarez, MCDBA, OCP
Database Administrator




> It has the expected SMTP server, but how did it get that info if I never
> specified it? Does 2005 scan the network looking for SMTP servers? Any idea
> about number 2?
>


> >
> > Hmmm, interesting. Run
> >
> > exec msdb.dbo.sysmail_help_account_sp
> >
> > and inspect the servertype, servername and port values.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >

> >
> > > Howdy all. For the record, I will never again wait this long to start
> > > learning about new versions of SQL Server, there is just too much. With
> that
> > > out of the way, I'm having issues/ misunderstandings about DB mail.
> > >
> > > 1; I just logged into my work and set up DBMail on my PC as we have an
> SMTP
> > > server there that I use all the time. I set it up, but was never asked
> to
> > > supply the name of my SMTP server. I sent out a test email, expecting it
> to
> > > fail, but it didn't. I know SQL Server is not magic, but how can it be?
> How
> > > can it know what SMTP server to use?
> > >
> > > 2; I set up a simple test job to verify that I would be emailed on
> failure.
> > > I specified it to use the same account from number 1 above as the
> Operator.
> > > However, when I ran my job that failed, I never got my email. What
> gives?
> > >
> > > TIA, ChrisR
> > >
> > >
> > >
>
>
>
 
 
ChrisR





PostPosted: Mon Jun 19 00:53:33 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail. Yes and yes.



>
> Did you went to SQL Server Agent Properties, Alert System and Enable mail
> profile to enable your mail system and mail profile?
>
> You are using 32-bit software, right?
>
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
>

>
> > It has the expected SMTP server, but how did it get that info if I never
> > specified it? Does 2005 scan the network looking for SMTP servers? Any
idea
> > about number 2?
> >


> > >
> > > Hmmm, interesting. Run
> > >
> > > exec msdb.dbo.sysmail_help_account_sp
> > >
> > > and inspect the servertype, servername and port values.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >

> > >
> > > > Howdy all. For the record, I will never again wait this long to
start
> > > > learning about new versions of SQL Server, there is just too much.
With
> > that
> > > > out of the way, I'm having issues/ misunderstandings about DB mail.
> > > >
> > > > 1; I just logged into my work and set up DBMail on my PC as we have
an
> > SMTP
> > > > server there that I use all the time. I set it up, but was never
asked
> > to
> > > > supply the name of my SMTP server. I sent out a test email,
expecting it
> > to
> > > > fail, but it didn't. I know SQL Server is not magic, but how can it
be?
> > How
> > > > can it know what SMTP server to use?
> > > >
> > > > 2; I set up a simple test job to verify that I would be emailed on
> > failure.
> > > > I specified it to use the same account from number 1 above as the
> > Operator.
> > > > However, when I ran my job that failed, I never got my email. What
> > gives?
> > > >
> > > > TIA, ChrisR
> > > >
> > > >
> > > >
> >
> >
> >


 
 
ChrisR





PostPosted: Mon Jun 19 01:05:50 CDT 2006 Top

SQL Server >> Questions on 2005 DBMail. I just totally disable, then re-enabled DBMail. Then I went to configure, I
type in a Profile name, then I click add. There is what I assume to be a
default Account1. If I accept it, it displays my email address. Still not
sure where its getting that info from. Anyways, if I click New Account, it
then asks me for the info(smtp server and such).

Thanks.



>
> I tested the New Account screen on the Database Mail Configuration Wizard
> and you can not configure the new account without specifying a server
Name.
> The Next button is disabled until you type something on Server name.
>
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
>

>
> > It has the expected SMTP server, but how did it get that info if I never
> > specified it? Does 2005 scan the network looking for SMTP servers? Any
idea
> > about number 2?
> >


> > >
> > > Hmmm, interesting. Run
> > >
> > > exec msdb.dbo.sysmail_help_account_sp
> > >
> > > and inspect the servertype, servername and port values.
> > >
> > > Ben Nevarez, MCDBA, OCP
> > > Database Administrator
> > >
> > >

> > >
> > > > Howdy all. For the record, I will never again wait this long to
start
> > > > learning about new versions of SQL Server, there is just too much.
With
> > that
> > > > out of the way, I'm having issues/ misunderstandings about DB mail.
> > > >
> > > > 1; I just logged into my work and set up DBMail on my PC as we have
an
> > SMTP
> > > > server there that I use all the time. I set it up, but was never
asked
> > to
> > > > supply the name of my SMTP server. I sent out a test email,
expecting it
> > to
> > > > fail, but it didn't. I know SQL Server is not magic, but how can it
be?
> > How
> > > > can it know what SMTP server to use?
> > > >
> > > > 2; I set up a simple test job to verify that I would be emailed on
> > failure.
> > > > I specified it to use the same account from number 1 above as the
> > Operator.
> > > > However, when I ran my job that failed, I never got my email. What
> > gives?
> > > >
> > > > TIA, ChrisR
> > > >
> > > >
> > > >
> >
> >
> >