Tuesday, 15 February 2011

Not able to send emails from SQL Server -



Not able to send emails from SQL Server -

my application , sql server available on godaddy server.i using below commands configure email in sql server :

execute msdb.dbo.sysmail_add_account_sp @account_name = 'g_testaccount_1', @description = 'mail business relationship used dba staff', @email_address = 'emailaddress', @display_name = 'dba mail', @replyto_address = 'emailaddress', @username='emailaddress', @password='passwordofemailaddress', @mailserver_name = 'smtpaddress'; execute msdb.dbo.sysmail_add_profile_sp @profile_name = 'g_test_profile_1', @description = 'mail profile utilize dba processes'; execute msdb.dbo.sysmail_add_profileaccount_sp @profile_name = 'g_test_profile_1', @account_name = 'g_testaccount_1', @sequence_number =1 ;

emails, default configured on port 25, have checked other ports 3535,587.my problem emails not working. error message : "a connection effort failed because connected party did not respond after period of time, or established connection failed because connected host has failed respond smtpaddress:25"

i have checked smtp through telnet , found response coming fine. have checked port not blocked site http://www.mynetworktest.com/ports.php

i have invested 2 days resolve issue , looking forwards help other professionals available here. please help me resolve issue.many in advance

sql sql-server-2008

No comments:

Post a Comment