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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-03-03 : 23:26:00
|
| I have a question on SQLMail and SQLAgentMail. I have read through sqlguru's article "SQLMail in Depth" (http://www.sqlteam.com/item.asp?ItemID=401) and the links provided in this article also. I am using a SQL Server on my workstation for testing purpose. On this computer, I use a local account to login, and to startup the MSSQLSERVER and SQLAgent services. It is NOT a domain account. I have installed Outlook 2002 on this computer to configure sending and receiving e-mail from my corporate Exchange Server. The sending and receiving of mail work fine. But I just fail to use SQLMail and SQLAgent Mail. For SQLMail, I can choose a profile under Support Services -> SQLMail -> Properties, and the profile tested correctly. But when I run the xp_sendmail stored procedure, it returns with the error: "Server: Msg 18025, Level 16, State 1, Line 0xp_sendmail: failed with mail error 0x80040111".For SQLAgentMail, in Management -> SQL Server Agent -> Properties-> Mail Session, I chose my mail profile and clicked "Test", it returned with an error "Error 22022: SQLServerAgentError: Unable to get the default MAPI Message Store due to MAPI error 273: The information store could not be opened."In the Common SQLMail Problem article published by Microsoft, I checked from the "Proper configuration" that I have followed all configurations except that the account I used to start SQLServer and SQLAgent is a local account (of my workstation) instead of a domain account. I could not try using domain account due to some limitations. Is this the reason for all the errors?Thank you very much,delpiero |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-04 : 12:11:26
|
| why don't you just change SQL services to run under your domain account? If this is for testing purposes, you shouldn't have a problem. In fact, your sqlmail/sqlagentmail will magically start to work.For a prod box you would never want to run the services under a regular user account for obvious reasons.-ec |
 |
|
|
|
|
|
|
|
SQLMail