I am trying to get SQL to receive emails, but having some difficulty. Found a blog which starts out with the use of the xp_startmail, but when I try to execute that, I am getting an error. The suggested solution for the error, didn't work...
USE MASTER
GO
SP_CONFIGURE 'show advanced options', 1;
GO
RECONFIGURE;
GO
SP_CONFIGURE 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
EXEC XP_STARTMAIL
GO
Msg 15281, Level 16, State 1, Procedure xp_startmail, Line 1
SQL Server blocked access to procedure 'sys.xp_startmail' of component 'SQL Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about enabling 'SQL Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.
Any help to get me started would be appreciated....
[EDIT]
**
The only way for SQL Server 2008 to receive email is by using the legacy stored procedures, such as sp_processmail, with SQL Mail. Database Mail does not support receiving incoming messages because there is no IMAP or POP3 support. This may have something to do with the fact that receiving email can represent a major security risk. Imagine what a denial-of-service attack on a database cluster could do to an organization. Or consider the danger of an incoming email request resulting in the execution of a query such as DROP DATABASE X. Most SQL Server data is too precious to jeopardize in this manner. Microsoft has also made it clear that SQL Mail will be phased out in the next release of SQL Server. Plus, there are many better alternatives to using this methodology, such as using native Web services , using .NET CLR-integrated assembly code
**
That's a bit of a nuisance, but makes sense.