June 6, 2005 at 3:30 am
Big problem and I don't know why..
SQL Mail doesn't work.
When I try do Mail out of SQL-Enterprice Manager it hangs.
When I try to Mail via Query and xp_sendmail it hangs also with no error. I cant stop the Query, i have to cancel the complete Query Analizer via Task Manager.
When I start Outlook 2000 on the Server I can send mails.
This is my Query(Example out of BOL):
EXEC xp_sendmail @recipients = 'e446812',
@message = 'The master database is full.',
@subject = 'Master Database Status'
After 8 minutes I get the Messange:
Query cancelled by User
[Microsoft][ODBC SQL Server Driver]Operation canceled
[Microsoft][ODBC SQL Server Driver]Timeout expired
ODBC: Msg 0, Level 16, State 1
Communication link failure
Connection Broken
___________________________________________________________
I hope anyone knows the Problem an can provide me with a solution.
Kind Regard
Michael
June 6, 2005 at 4:28 am
You has been check the mail profile in your server?
Regards
-Deni-
June 6, 2005 at 5:38 am
Hi,
the profile is ok, i can send Mail out of Outlook.
June 7, 2005 at 2:13 am
When you say you can send email...
Can you send email from Outlook logged onto the server as the sql service account?
Have you set up SQL Agent Mail and an operator and can you send an test email from EM there?
I know some folks have problems with Outlook 2003.
Some of the servers here take 2 mins to load the mail profile during SQL agent startup because of Outlook 2003
Just a few thoughts...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply