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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-17 : 09:35:50
|
| Tim writes "Hi,Im getting the following error and struggling to find a resolution on the web. MSSQL2000SP2, Terminal Services running on server also.Microsoft SQL-DMO(ODBC SQL State: 42000) Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog.THis only appears when I create the operator and try to test the email, the mailprofile, SQLServerAgent and SQLServer all start with the same user.When I test the Mail Prilfe via the SQL Server Agent props/General Tab it works...responds with no errors.Any pointers appreciated.....ThankxTim" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-04-23 : 16:51:00
|
| SQL mail is more than a little flaky. It is possible for it to test successfully, but not be in a state to send mail, or even be operating. You may wish to try restarting the service -HOWEVER- be careful! More often than not, I find that shutting down SQL mail just locks it up. I then have to restart SQL Agent, which is also likely to lock up. When I try to restart SQL Server, IT LOCKS UP. We've even had problems where the server failed to come back up on the first reboot. Be certain you are willing and able to physically reboot the server before shutting down SQL Agent. |
 |
|
|
karlsd
Starting Member
2 Posts |
Posted - 2002-07-26 : 14:49:18
|
| i am getting the same exact error. Restarting the SQL Services only temporarly relieves the issue. After logging off and then back on the issue arrises again. I am seriously thinking that intalling Terminal Services is the cause of the issue. My email reports, I believe have discontinued since installing TS and they never worked on a different server that was initally installed with TS. |
|
|
|
|
|
|
Error 22022: SQLServerAgent