configure Database Mail - SQL Server Forums

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 Administration

configure Database Mail

Author

Topic

Kimi86
Yak Posting Veteran

79 Posts

Posted - 2013-05-15 : 07:34:23

What access do I need to configure Database Mail in Sql Server 2008.
Right now I cant even see the MAangement folder on Obeject explorer windoe on SSMS

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-05-15 : 08:20:55

sysadmin server role, per this MSDN page: http://msdn.microsoft.com/en-us/library/ms187605.aspx

prett
Posting Yak Master

212 Posts

Posted - 2013-05-16 : 03:00:00

To configure mail, you need to enable the Database Mail XPs parameter through the sp_configure stored procedure:

sp_CONFIGURE 'show advanced', 1
GO
RECONFIGURE
GO
sp_CONFIGURE 'Database Mail XPs', 1
GO
RECONFIGURE
GO

For more information, please check this post: http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources