|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > xp_sendmail problems
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
xp_sendmail problems
|
|
| Tim Wagaman 2002-10-31, 10:23 am |
| For starters, I am using:
Winows 2000 Server SP2
SQL Server 2000 SP2
Outlook 2000 No service pack installed (ver 9.0.0.2711)
Exhange 5.5 SP3 (Located on an NT4 Server)
I have configured SQL Mail properly by all the checks in the following
articles:
http://support.microsoft.com/defaul...b;en-us;Q311231
http://support.microsoft.com/defaul...b;en-us;Q263556
http://support.microsoft.com/defaul...b;en-us;Q315886
Yet, I cannot send mail. I use this code in Query Analyzer:
<begin Code>
exec master..xp_sendmail
@recipients='tim_wagaman@therm
oset.com',
@subject='test',
@message='Test123'
<End code>
I get inconsistant error messages... I get:
<begin error messages>
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80070005
One other that I can't seem to reproduce...
<end error messages>
What am I doing wrong? is there anything else I can try?
Any help is appreciated.
Tim
| |
| Tim Wagaman 2002-10-31, 11:23 am |
| Oh, yeah, the other error is that sometimes it just hangs...
(I can send email trhough outlook 2K with out any dialogs appearing)
"Tim Wagaman" <Tim_WagamanNOSPAM@Thermoset.com> wrote in message
news:#ZWzEkPgCHA.2424@tkmsftngp11...
> For starters, I am using:
> Winows 2000 Server SP2
> SQL Server 2000 SP2
> Outlook 2000 No service pack installed (ver 9.0.0.2711)
> Exhange 5.5 SP3 (Located on an NT4 Server)
>
> I have configured SQL Mail properly by all the checks in the following
> articles:
> http://support.microsoft.com/defaul...b;en-us;Q311231
> http://support.microsoft.com/defaul...b;en-us;Q263556
> http://support.microsoft.com/defaul...b;en-us;Q315886
>
> Yet, I cannot send mail. I use this code in Query Analyzer:
> <begin Code>
> exec master..xp_sendmail
> @recipients='tim_wagaman@therm
oset.com',
> @subject='test',
> @message='Test123'
> <End code>
>
> I get inconsistant error messages... I get:
> <begin error messages>
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x80070005
>
> One other that I can't seem to reproduce...
> <end error messages>
>
> What am I doing wrong? is there anything else I can try?
>
> Any help is appreciated.
> Tim
>
>
| |
| James Hunter Ross 2002-10-31, 12:24 pm |
| My favorite debugging step is to sit down at the server console, log on as
the same user used for the SQL Server service account, fire up Outlook, and
send a message. If you have not done this yet, give it a try.
James
| |
| Tim Wagaman 2002-10-31, 12:24 pm |
| Yeah, I already tried that. And it didn't help because the email went out
with no problems... no dialog boxes... recieved it just fine.
"James Hunter Ross" <jhr@delta.net> wrote in message
news:OVcyPaQgCHA.392@tkmsftngp09...
> My favorite debugging step is to sit down at the server console, log on as
> the same user used for the SQL Server service account, fire up Outlook,
and
> send a message. If you have not done this yet, give it a try.
>
> James
>
>
| |
| Jasper Smith 2002-10-31, 1:24 pm |
| 1) Stop all SQL Services
2) Rename sqlmap70.dll
3) Get sqlmap70.dll from either the Original CD or SP1
and replace the existing version in the Binn folder
4) Restart Services
--
HTH
Jasper Smith (SQL Server MVP)
Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm
"Tim Wagaman" <Tim_WagamanNOSPAM@Thermoset.com> wrote in message
news:eCHSJfQgCHA.2516@tkmsftngp11...
> Yeah, I already tried that. And it didn't help because the email went out
> with no problems... no dialog boxes... recieved it just fine.
>
> "James Hunter Ross" <jhr@delta.net> wrote in message
> news:OVcyPaQgCHA.392@tkmsftngp09...
> > My favorite debugging step is to sit down at the server console, log on
as
> > the same user used for the SQL Server service account, fire up Outlook,
> and
> > send a message. If you have not done this yet, give it a try.
> >
> > James
> >
> >
>
>
| |
| James Hunter Ross 2002-10-31, 1:24 pm |
| Ok. This is going to sound wierd, and I'll probably come across as an
idiot, but I'll describe a problem I had, and still have no solution for...
CORP\SQLMail is the SQL service account, and the account has an exchange
mailbox (or whatever, I don't know exchange). I am CORP\James and I have a
mailbox too.
If I logged on to the server box as CORP\SQLMail and opened Outlook, (just
like you have done successfully), AND THEN opened QA and executed
xp_sendmail, it would work great! I could even then close Outlook, and
xp_sendmail still worked. I spent tons of time on this once I got the
xp_sendmail to work this way, but ultimately never got things worked out so
that the xp_sendmail would work without me being logged on to the console as
CORP\SQLMail with Outlook opened at least once. The problem almost seemed
to happen only if I was logged on to the SQL box as CORP\James, almost as if
exchange was trying to use the CORP\James mailbox even though I was
executing the xp_sendmail command from QA.
I cut my losses and gave up, but my final impression was that exchange was
deciding upon which mailbox to use based on the name associated with whoever
first connect to it "from that particular machine". This thought, I will
admit, is basically superstition, but it was the best I could deduce, not
knowing how exchange works.
Don't get me wrong, we do have SQL Mail working here very reliably. But, on
our servers, there are never other users logged on doing mail stuff. I
mention all this because your symptom sounds very similar. I hope it helps
in some way.
James
| |
| Rick Foelsch 2002-10-31, 1:24 pm |
| Tim,
This is a recorded bug that I receive a lot using xp_sendmail. It has been
recorded as fixed in the SQL2K sp3 fix list which is in beta testing right
now. You could also look at using CDO; KB: Q312839.
Rick
"Tim Wagaman" <Tim_WagamanNOSPAM@Thermoset.com> wrote in message
news:#ZWzEkPgCHA.2424@tkmsftngp11...
> For starters, I am using:
> Winows 2000 Server SP2
> SQL Server 2000 SP2
> Outlook 2000 No service pack installed (ver 9.0.0.2711)
> Exhange 5.5 SP3 (Located on an NT4 Server)
>
> I have configured SQL Mail properly by all the checks in the following
> articles:
> http://support.microsoft.com/defaul...b;en-us;Q311231
> http://support.microsoft.com/defaul...b;en-us;Q263556
> http://support.microsoft.com/defaul...b;en-us;Q315886
>
> Yet, I cannot send mail. I use this code in Query Analyzer:
> <begin Code>
> exec master..xp_sendmail
> @recipients='tim_wagaman@therm
oset.com',
> @subject='test',
> @message='Test123'
> <End code>
>
> I get inconsistant error messages... I get:
> <begin error messages>
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x80070005
>
> One other that I can't seem to reproduce...
> <end error messages>
>
> What am I doing wrong? is there anything else I can try?
>
> Any help is appreciated.
> Tim
>
>
| |
| Jeff Boyd 2002-10-31, 2:23 pm |
| Check out
http://support.microsoft.com/defaul...b;en-us;Q320407
and
http://support.microsoft.com/defaul...b;en-us;Q329375
"Tim Wagaman" <Tim_WagamanNOSPAM@Thermoset.com> wrote in message
news:#ZWzEkPgCHA.2424@tkmsftngp11...
> For starters, I am using:
> Winows 2000 Server SP2
> SQL Server 2000 SP2
> Outlook 2000 No service pack installed (ver 9.0.0.2711)
> Exhange 5.5 SP3 (Located on an NT4 Server)
>
> I have configured SQL Mail properly by all the checks in the following
> articles:
> http://support.microsoft.com/defaul...b;en-us;Q311231
> http://support.microsoft.com/defaul...b;en-us;Q263556
> http://support.microsoft.com/defaul...b;en-us;Q315886
>
> Yet, I cannot send mail. I use this code in Query Analyzer:
> <begin Code>
> exec master..xp_sendmail
> @recipients='tim_wagaman@therm
oset.com',
> @subject='test',
> @message='Test123'
> <End code>
>
> I get inconsistant error messages... I get:
> <begin error messages>
> SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>
> SQL Mail session started.
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x80070005
>
> One other that I can't seem to reproduce...
> <end error messages>
>
> What am I doing wrong? is there anything else I can try?
>
> Any help is appreciated.
> Tim
>
>
|
|
|
|
|