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 |
SQLNilo
Starting Member
2 Posts |
Posted - 2006-05-10 : 13:48:06
|
ERROR: "xp_sendmail: failed with mail error 0x80040111"I obtain to send emails with the xp_sendmail in the SQL Server 2000 when I configure the account in Outlook 2003, but I made a test using Outlook 2002 (Office XP) and it did not work, gives the error. Does somebody have some tip? Thanks!! |
|
SQLNilo
Starting Member
2 Posts |
Posted - 2006-05-11 : 11:42:39
|
quote: Originally posted by SQLNilo ERROR: "xp_sendmail: failed with mail error 0x80040111"I obtain to send emails with the xp_sendmail in the SQL Server 2000 when I configure the account in Outlook 2003, but I made a test using Outlook 2002 (Office XP) and it did not work, gives the error. Does somebody have some tip? Thanks!!
I found how to make it works, see the steps:1) Alterei as propriedades para o serviço do SQL e o serviço do Agent iniciarem com uma conta que não fosse system, ou seja, iniciar com um usuário de rede.2) Reiniciei o micro e loguei com o usuário que definido no passo 1.3) Configurei o Outlook no mesmo perfil de usuário usado para iniciar o SQL e o Agent (era este o segredo para funcionar).Ai funcionou que foi uma maravilha... rsrsForte abraço!! |
|
|
|
|
|