Wednesday, March 28, 2012

killing SQLmail

Our SQLMail stopped working, so I tried to stop and
restart the SQLMail using xp_stopmail and xp_startmail.
it stopped quickly, but when I ran xp_startmail, it
appeared to hang. I killed the process, now it's saying
that it's "Killed/Rollback". It's been like that for a
while now. Does anyone know a way to get rid of this?
Can this cause other headaches?
Rob,
Are you using Microsoft Exchange? Is the Exchange Server available? This
can happen when Exchange disappears, or you lose connectivity to it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Rob wrote:
> Our SQLMail stopped working, so I tried to stop and
> restart the SQLMail using xp_stopmail and xp_startmail.
> it stopped quickly, but when I ran xp_startmail, it
> appeared to hang. I killed the process, now it's saying
> that it's "Killed/Rollback". It's been like that for a
> while now. Does anyone know a way to get rid of this?
> Can this cause other headaches?
|||> This can happen when Exchange disappears
I'd question David Copperfield. ;-)
Oh, I can't wait for a more robust and independent mail platform in SQL
Server...
http://www.aspfaq.com/
(Reverse address to reply.)
|||I already tried that - that was also my first thought that is was because is
was doing it under wrong uder name, but that's not the case. I', logged in
to the server as the user that runs the SQLServer Agent service, and I can
open Outlook and get into the mailbox without any problems.
Regards
Steen
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:OtVlLiCZEHA.2500@.TK2MSFTNGP09.phx.gbl...
> I'd question David Copperfield. ;-)
> Oh, I can't wait for a more robust and independent mail platform in SQL
> Server...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||Steen,
Can you send mail from Outlook, logged on as the SQLAgent account?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Steen Persson wrote:
> I already tried that - that was also my first thought that is was because is
> was doing it under wrong uder name, but that's not the case. I', logged in
> to the server as the user that runs the SQLServer Agent service, and I can
> open Outlook and get into the mailbox without any problems.
> Regards
> Steen
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
> news:OtVlLiCZEHA.2500@.TK2MSFTNGP09.phx.gbl...
>
>
|||...it seems like my previous reply to my problem has ended up in a wrong
thread - sorry 'bout that.
I have verified that I can send emails from Outlook. Everything seems to be
fine - I log on as the user that runs the SQL agent which is the same as the
user of the mailbox. The strange thing is that it worked fine the other day
when I installed Outlook on a few SQL servers, but now it fails with the
same error message on all of them. I'm wondering if there's something stupid
that I'm missing when I fire the xp_sendmail command.
The command I'm trying with just for the test is:
Use Master
EXEC xp_sendmail 'spe@.MyDomainName.dk', ' Test'
Shoudn't this be enough just to send an email or am I missing something?
Regards
Steen
"Mark Allison" <marka@.no.tinned.meat.mvps.org> skrev i en meddelelse
news:eFy9YYDZEHA.996@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Steen,
> Can you send mail from Outlook, logged on as the SQLAgent account?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Steen Persson wrote:
because is[vbcol=seagreen]
in[vbcol=seagreen]
can[vbcol=seagreen]

No comments:

Post a Comment