SQL Mail Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Mail Error

Author

Topic

victord
Yak Posting Veteran

64 Posts

Posted - 2005-07-20 : 11:48:43

hi,
i am trying to set up sql mail on my sql server 2000 machine. i have managed to set it in sql mail ,but sql agent mail seem to be failing.

I have set it up with the same mail profile and tested it in both enviroments. It worked in sql mail but comes up with an error when tested in sql agent mail.

" Error 22022, the time-out was exceeded while the server waited for a responce from sql server agent. make sure that the sql server agent service is working." What am i doing wrong and what doi need to do to correct this error.

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-07-20 : 11:56:02

well is is the sql agent running? does'nt startup automatically unless you set it up too.

Sean Roussy

Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.

I am available for consulting work. Just email me through the forum.