Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Server
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 7-Jan-13 1:02am
Comments
CHill60 at 7-Jan-13 6:28am
   
Have you seen this article?
http://www.codeproject.com/Articles/485124/Configuring-Database-Mail-in-SQL-Server
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Comments
naresh1252 at 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.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

I hope this is not a SQL Server Express installation........ is it?
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 5,170
1 DamithSL 4,357
2 Maciej Los 3,750
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,851


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100