Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
We have a database sql server 2008 r2.
But i had a problem with the database mail option in management category.
Can anyone tell me how to activate the database mail concept in sql server.
I know how to create profiles and send test mails through the database, but the issue is i am unable to access the database mail option. So is it an installation problem or any stored procedures to be generated ?


And when i try to start 'sqlserver agent' in the services page its showing an error like 'the sql server agent service on local computer started and stopped.Some services stop automatically if they are not in use by other service or programs'

So please anyone have any solution towards these issues which i am working with.

thank you
best regards
Posted
Comments
CHill60 7-Jan-13 6:28am    
Have you seen this article?
http://www.codeproject.com/Articles/485124/Configuring-Database-Mail-in-SQL-Server

You first need to enable database mail ... here is the code

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



The profiles and accounts will work fine after this.
 
Share this answer
 
Comments
naresh1252 7-Jan-13 6:57am    
thank you for the reply ,
yes i executed these sp's but the issue is there is no option like
'database mail' in the management category.
I hope this is not a SQL Server Express installation........ is it?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900