SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 configure Database Mail
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kimi86
Yak Posting Veteran

65 Posts

Posted - 05/15/2013 :  07:34:23  Show Profile  Reply with Quote
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


Edited by - Kimi86 on 05/15/2013 07:36:42

James K
Flowing Fount of Yak Knowledge

3559 Posts

Posted - 05/15/2013 :  08:20:55  Show Profile  Reply with Quote
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

USA
192 Posts

Posted - 05/16/2013 :  03:00:00  Show Profile  Visit prett's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000