Help! SQL Mail

We have SQL mail set up and running for a while, recently we upgrade our
exchange from 2000 to 2003 (in same domain but different servers), and mail
client software is still Outlook 2000 in SQL Server box. I update the mail
profile to using new mail server. No we experience a problem when we tried to
send email from SQL server. Following is error message
xp_sendmail :failed with mail error 0x8004011d. SQL mail session started.
I tested sent email from outlook, it worked fine, and also tested in SQL
mail configuration page, it stopped and started email session fine. I also
tried re-boot server, still get that error. Does anyone know how to solve of
this issue?
ThanksZou,
Have you updated the SQL Mail profile in SQL Agent as well?
May be you have to cofigure sql mail and test it out there
"Yong Zou" wrote:
> We have SQL mail set up and running for a while, recently we upgrade our
> exchange from 2000 to 2003 (in same domain but different servers), and mail
> client software is still Outlook 2000 in SQL Server box. I update the mail
> profile to using new mail server. No we experience a problem when we tried to
> send email from SQL server. Following is error message
> xp_sendmail :failed with mail error 0x8004011d. SQL mail session started.
> I tested sent email from outlook, it worked fine, and also tested in SQL
> mail configuration page, it stopped and started email session fine. I also
> tried re-boot server, still get that error. Does anyone know how to solve of
> this issue?
> Thanks|||I tried to update SQL Mail profile in SQL Agent, and I got following error
when I click test
Error 22022: SQLServerAgent Error: Unable to get the default MAPI Message
Store due to MAPI error 285: The attempt to log on to the Microsoft Exchange
Server Computer has failed.
Again, I can send and receive emails using outlook 2000 in that box. Any
idea about this error
Thanks
Yong
"Rashmi Jagadish" <RashmiJagadish@.discussions.microsoft.com> wrote in
message news:77449052-536C-4A72-8A76-027A0842BE02@.microsoft.com...
> Zou,
> Have you updated the SQL Mail profile in SQL Agent as well?
> May be you have to cofigure sql mail and test it out there
>
> "Yong Zou" wrote:
> > We have SQL mail set up and running for a while, recently we upgrade our
> > exchange from 2000 to 2003 (in same domain but different servers), and
mail
> > client software is still Outlook 2000 in SQL Server box. I update the
mail
> > profile to using new mail server. No we experience a problem when we
tried to
> > send email from SQL server. Following is error message
> >
> > xp_sendmail :failed with mail error 0x8004011d. SQL mail session
started.
> >
> > I tested sent email from outlook, it worked fine, and also tested in SQL
> > mail configuration page, it stopped and started email session fine. I
also
> > tried re-boot server, still get that error. Does anyone know how to
solve of
> > this issue?
> >
> > Thanks|||The first error indicates that SQL Mail cannot logon to your
mail server with the information you have provided in your
mail profile. The second error on the test is the same
issue. The mail profiles aren't configured properly. You can
find information on configuring mail in the following
article:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Mon, 8 Nov 2004 10:39:00 -0500, "Yong Zou
\(SearchIgnite\)" <yz@.yz.com> wrote:
>I tried to update SQL Mail profile in SQL Agent, and I got following error
>when I click test
>Error 22022: SQLServerAgent Error: Unable to get the default MAPI Message
>Store due to MAPI error 285: The attempt to log on to the Microsoft Exchange
>Server Computer has failed.
>Again, I can send and receive emails using outlook 2000 in that box. Any
>idea about this error
>Thanks
>Yong
>"Rashmi Jagadish" <RashmiJagadish@.discussions.microsoft.com> wrote in
>message news:77449052-536C-4A72-8A76-027A0842BE02@.microsoft.com...
>> Zou,
>> Have you updated the SQL Mail profile in SQL Agent as well?
>> May be you have to cofigure sql mail and test it out there
>>
>> "Yong Zou" wrote:
>> > We have SQL mail set up and running for a while, recently we upgrade our
>> > exchange from 2000 to 2003 (in same domain but different servers), and
>mail
>> > client software is still Outlook 2000 in SQL Server box. I update the
>mail
>> > profile to using new mail server. No we experience a problem when we
>tried to
>> > send email from SQL server. Following is error message
>> >
>> > xp_sendmail :failed with mail error 0x8004011d. SQL mail session
>started.
>> >
>> > I tested sent email from outlook, it worked fine, and also tested in SQL
>> > mail configuration page, it stopped and started email session fine. I
>also
>> > tried re-boot server, still get that error. Does anyone know how to
>solve of
>> > this issue?
>> >
>> > Thanks
>

Help!

Help,
i have a nt server sp6 with sql sp3 installed and configured by someone
else. in recent weeks our dc/exchange server had a similar problem in where
i had to do a reinstall from scratch and restore from backup.
because of user accounts being recreated i had to go and add the users again
on the sql server.
i decided to reboot the server after completing the task of adding the
users. then the fun began... the server will past the post, no problem, then
when the winnt server logo would appear on the screen with the mouse
cursor...wham the server started to reboot in an endless loop...right at the
same spot, the winnt logo screen and mouse cursor being displayed on the
screen.
I figured i post this here since this happened right after adding the users
in sql.
it looks like a virus at play but none was detected before the server was
rebooted.
has anybody seen this happen before?
can this configuration be saved ?
any help would be greatly appreciated.
thanks
ronaldHi ,
Ask your system administrater to try out this,
I am merely guessing, try this:
get to system using Console Repair Mode and then change
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Wi
ndowsNT\CurrentVersion\Winlogon\Auto
AdminLogon to 0
also if that doesn't help, try to go to your %temp% folder and delete
sit*.tmp files, which the Readme says are used to store the passwords.
Thanks
Hari
MCDBA
"ronald" <ronald_padilla@.msn.com> wrote in message
news:ufR2qMIEEHA.3408@.tk2msftngp13.phx.gbl...
> Help,
> i have a nt server sp6 with sql sp3 installed and configured by someone
> else. in recent weeks our dc/exchange server had a similar problem in
where
> i had to do a reinstall from scratch and restore from backup.
> because of user accounts being recreated i had to go and add the users
again
> on the sql server.
> i decided to reboot the server after completing the task of adding the
> users. then the fun began... the server will past the post, no problem,
then
> when the winnt server logo would appear on the screen with the mouse
> cursor...wham the server started to reboot in an endless loop...right at
the
> same spot, the winnt logo screen and mouse cursor being displayed on the
> screen.
> I figured i post this here since this happened right after adding the
users
> in sql.
> it looks like a virus at play but none was detected before the server was
> rebooted.
> has anybody seen this happen before?
> can this configuration be saved ?
> any help would be greatly appreciated.
> thanks
> ronald
>|||thanks guys.
the server was configured with raid 5 and getting to the registry was a
problem. i needed a way to get to the sql data. i used a independant "hd"
from the raid 5 and was able to back up the data to then restore sql .
again thanks
ronald
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AOgoRJEEHA.3016@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> Ask your system administrater to try out this,
> I am merely guessing, try this:
> get to system using Console Repair Mode and then change
>
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Wi
ndowsNT\CurrentVersion\Winlogon\Auto[col
or=darkred]
> AdminLogon to 0
> also if that doesn't help, try to go to your %temp% folder and delete
> sit*.tmp files, which the Readme says are used to store the passwords.
> Thanks
> Hari
> MCDBA
>
> "ronald" <ronald_padilla@.msn.com> wrote in message
> news:ufR2qMIEEHA.3408@.tk2msftngp13.phx.gbl...
> where
> again
> then
> the
> users
was
>