Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Enable DB Mail-slight confusion

Author  Topic 

savior faire
Posting Yak Master

194 Posts

Posted - 2008-06-12 : 09:22:14


Good morning all.
I am new with SQL 2005, and am experiencing some confusion with how database mail can be enabled. The SQL Server Books online and the online documentation is a bit vague.

SQL Server Books online says DB Mail may be enabled in two ways:
1. SQL Server Surface Area Configuration Tool
2. Database Mail Confige Wizard

In another section of Books Online it says one may use a series of sp_configure stored procedures(I'll omit them). This section goes on to say that if one uses the Wizard then you do no need to execute the stored procedure enabling.

So, this means there are three ways to enable Database Mail, correct?

Thanks... great forum.
[8D

Talk sense to a fool and he calls you foolish.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-14 : 18:16:26
Use config wizard, easier to set. By the way, you still need wizard to config db mail after enabling it in Surface Area Configuration.
Go to Top of Page

savior faire
Posting Yak Master

194 Posts

Posted - 2008-06-15 : 12:02:25
Thanks for the reply. Got it configured and was able to send emails using the smtp server of my ISP. Very interesting....


Talk sense to a fool and he calls you foolish.
Go to Top of Page
   

- Advertisement -