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-09-04 : 11:13:18
|
| Kenny writes "Dear SupportI get an error while we config an operatoe using SQL mail, the error like this "Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServer Agent service startup account in the SQLServerAgent properites dialog", I aready created a mail profile from the control panel, but i can't use it in the SQL mail's properties setting, it shows nothing in it, I can't understanding why ?? Please help !! Many thanks !Best reagardsKenny" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-09-04 : 11:46:51
|
| Sounds like you might have created that mail profile under your personal account (the account that you use yourself to log into the server). But unless your SQL Agent is using the same account (and it probably isn't) it won't be able to see this mail profile of yours. Using Enterprise Manager, go to SQL Agent properties, click on General tab, and make sure that SQL Agent runs in the domain account. Then log out of Windows and log back in, using credentials of the SQL Agent startup account, and create a new mail profile there. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-04 : 15:03:54
|
| Also on Win2K and SQL2000 you need to reboot for the profile to be visible in SQL. Other useful reading :-Exchange 2000 + SQL2000[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q293422[/url]SQL Mail[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321183[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q311231[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281293[/url]Support Web Cast[url]http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp[/url]HTHJasper Smith |
|
|
|
|
|
|
Get error while config operator though SQL mail