<CindyWinegarden@newsgroups.nospam> wrote:

>My goal is to send notification emails to myself/coworkers from SQL Server
>2005 Database Mail. At this point there will not be any incoming mail
>activity on this server. It's ok with me if I send email as myself rather
>than a local account specifically for the SQL Server.
>
>I'm using W2003 Server Standard and SQL2005 Standard. IIS and Pop3 are
>installed but not configured. I'm at a university and part of an Active
>Directory domain. Computer name is like MyServer.MyDomain.University.edu.
>The University has an SMTP server: smtp.university.edu.
>
>
>I'm clueless about all of this. I don't know whether I need SMTP running on
>my server or just the default SMTP Virtual Server in order to send mail via
>the university's SMTP, or whether I should just be my own mail server. I've
>read Kristofer Gafvert's article at www.ilopia.com .
>
>Most likely my network admin and the guys who own the university's SMTP
>server have no experience with SQL2005. Before/if I need to get them
>involved I'd like to understand as much as possible about the whole
>situation.
>
>
>Using only the default SMTP server I was able to use SQL 2005 Database Mail
>to a private email server I have access to, but it would only accept mail to
>an address on that server. I assume that means I had set up the SQL Database
>Mail correctly.
>
>
>Do I need to run a POP3/SMTP server on my machine? If so, in the POP3
>snap-in I see "Connect to another Server" at the POP3 Service level and "New
>Domain" at the MyServer level of the tree. Do I do anything with these?
>
>In the Default SMTP Virtual Service Properties, General tab: Do I use "All
>Unassigned" or my IP? Access tab: The article covers these settings.
>Delivery: Outbound Security - what goes there? Advanced delivery: Do I need
>to masquerade as University.edu to use the University's SMTP server?
>
>Where do I start? Thanks in advance for helping me.

"Jeff Cochran" <jeff.nospam@zina.com> wrote in message
news:44cd8484.273492265@msnews.microsoft.com...
> On Fri, 21 Jul 2006 13:38:19 -0400, "Cindy Winegarden"
> <CindyWinegarden@newsgroups.nospam> wrote:
>
>>My goal is to send notification emails to myself/coworkers from SQL Server
>>2005 Database Mail. At this point there will not be any incoming mail
>>activity on this server. It's ok with me if I send email as myself rather
>>than a local account specifically for the SQL Server.
>>
>>I'm using W2003 Server Standard and SQL2005 Standard. IIS and Pop3 are
>>installed but not configured. I'm at a university and part of an Active
>>Directory domain. Computer name is like MyServer.MyDomain.University.edu.
>>The University has an SMTP server: smtp.university.edu.
>>
>>
>>I'm clueless about all of this. I don't know whether I need SMTP running
>>on
>>my server or just the default SMTP Virtual Server in order to send mail
>>via
>>the university's SMTP, or whether I should just be my own mail server.
>>I've
>>read Kristofer Gafvert's article at www.ilopia.com .
>>
>>Most likely my network admin and the guys who own the university's SMTP
>>server have no experience with SQL2005. Before/if I need to get them
>>involved I'd like to understand as much as possible about the whole
>>situation.
>>
>>
>>Using only the default SMTP server I was able to use SQL 2005 Database
>>Mail
>>to a private email server I have access to, but it would only accept mail
>>to
>>an address on that server. I assume that means I had set up the SQL
>>Database
>>Mail correctly.
>>
>>
>>Do I need to run a POP3/SMTP server on my machine? If so, in the POP3
>>snap-in I see "Connect to another Server" at the POP3 Service level and
>>"New
>>Domain" at the MyServer level of the tree. Do I do anything with these?
>>
>>In the Default SMTP Virtual Service Properties, General tab: Do I use "All
>>Unassigned" or my IP? Access tab: The article covers these settings.
>>Delivery: Outbound Security - what goes there? Advanced delivery: Do I
>>need
>>to masquerade as University.edu to use the University's SMTP server?
>>
>>Where do I start? Thanks in advance for helping me.
>
> I'd start by using the University's mail server and not installing
> SMTP. SQL 2005 doesn't care, it just needs to be pointed to the SMTP
> server. See a SQL group for help on that and check wth your
> University's mail admins to see if you're allowed to use their server.
>
> Jeff