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
Go to Top of Page

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/
Go to Top of Page
   

- Advertisement -