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 |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2002-10-10 : 09:02:09
|
| SQL Server 7Outlook XPWindows NT4We are using exchange for setting this up.I have searched this site, MSDN etc to little end.........I asked our IT dept to set up SQLMail on a Server with the above on it.All the login accounts are the same one for everything (machine, mail profile etc)The Profile name is: IIRGSQLwhich i believe is ok. No funny characters there.The SQLMail service is running and tests (stop > starts) ok with the above profile.The SQL Server Agent is running and tests ok with the above profile and like i say the startup account is the same as the machine login account which has administrator rights. It has the domain name in the account box as well i.e. domainname\loginnameThe problem is when i set myself up as an operator and click the test button i get an error message saying the following:Error 22022: SQLServerAgentError: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog.The Agent IS running and is set to automatic ?? and like i say tests (stop > starts) ok.Searching MSDN etc with this error code yields little helpful info.Anyone have any ideas ??Is using Outlook XP a problem ??It seems as though it should work but doesn't ??I can use the netmessaging bit ok if that helps at all ??thanks for any help===========Paul |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-10 : 14:32:47
|
| Although I don't have an answer for you, this server here has been successfully setup to send email through outlook XP (winNT 4.0 and sql server 7.0) SO it's not outlook xp-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-10-10 : 16:01:00
|
| Also, login through Query analyzer and try running the xp_sendmail to make sure SQLMail works. |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-11 : 05:20:16
|
| Nope xp_sendmail doesn't work eitherI get a general MAPI failureMsg 17902, Level 18, State 1, Line 0===========Paul |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-11 : 07:01:51
|
| The operator part now works. It needed a change of operator name to match my mail name.However, xp_sendmail still does not work with the following messageServer: Msg 17903, Level 18, State 1, Line 0MAPI login failure.===========Paul |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-11 : 07:05:21
|
Have a look at INF: How to Configure SQL Mail[url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q263556&[/url]specifcally the bit on Outlook XP (2002) quote:
In Outlook 2002, the MAPI spooler logic was moved in-process, so any non-Exchange messages sent (such as those to an Internet mail server) require the Outlook client to be actively running on the server computer. If the Outlook client is not left open, outgoing messages will remain in the Inbox until such time as the Outlook client is opened when they will be sent. This behavior is not seen with messages sent to an Exchange server.The Microsoft Outlook 2002 e-mail security features provide additional levels of protection against malicious e-mail messages. The important feature from the SQL Mail perspective is the confirmation of automatic sending of e-mail messages. Because the security features are triggered by a simple MAPI connection, Outlook 2002 when used with SQL Mail on SQL Server 6.5 and SQL Server 7.0 may cause SQL Mail to hang due to the security pop-up screen. Contact your Exchange administrator to see if it is possible to relax the default security constraints.
HTHJasper Smith |
|
|
|
|
|
|
|
|
SQLMail problem