in configuration there is no problem.

in mail account need to make allow less secure apps-- ON.

this is the only required remaining all the same.

hi Steve Jones,subramanian.esakkimuthu ,ThomasRushton,Brandie Tarvin

i solved the issue regarding database mail.

thanks to everyone.who ever helped me to solve this one.

hi

i have entered all the valid details,

enabled service broker,enabled mail in agent server and restarted,i have made Database Mail XPs run value 1,

smtp server:smtp.gmail.com

port:587

when ever i sent the test...

hi

i am getting the error like this

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1007 (2016-06-11T23:01:39). Exception...

Hi

yes it is the sql server 2012.

i have done all the things still mail is not sending the status is failed its saying.

i uploaded the screen... please suggest the solution

Hi

i tried this but its giving the error like this

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62

The configuration option 'Database Mail XPs' does not exist, or it may...

Hi

yes i want to use smtp server to send out email from sql server ??

Thanks Steve Jones and HappyGeek

i solved my issue with the help of you.

Hi

how can i restart the windows host?.

i am sharing the file also.

hope it may usefull

select log_reuse_wait_desc from sys.databases

result

0 = Nothing

1 = Checkpoint, waiting for a checkpoint to occure

2 = Log backup, waiting for a log backup to occur ...

hi

there are 3 reasons to cause log file growth.

1) long running query (or) bulk transactions done at a time.

2)transaction log backups are not taken (or) not running.

3)active VLFs.

1ans: need...