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