Maybe this explains the issue I am finding with SQLMail

http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;313969
I don't get those errors from SQL Server. I get an error from Microsoft = Outlook 2003 that 'the folders cannot be created' if I allow SQL Server = Agent to start at boot in Windows 2000 SP3 and then try to open = Microsoft Outlook 2003. We have to use the same profile in SQL Mail as = we use in Microsoft Outlook 2003 because if we don't the SQL Mail will = never be sent. Therefore SQL Mail and Microsoft Outlook 2003 are both = using the same pst.
Hmmm...
If SQL Server Agent starts at boot ( a little problem here) then = Microsoft Outlook 2003 will not start. So don't allow SQL Server Agent = to start at boot and use a different profile for SQL Mail then I use to = start Microsoft Outlook 2003. Then SQL Mail will not be able to send = the mail until I close down Microsoft Outlook 2003 in my main profile = and open it in the profile I have SQL Mail set to. But of course I also = have to close down SQL Server Agent to do this. Man what a humdinger.
-- George Hester
__________________________________Try xp_smtp_sendmail from www.sqldev.net.
It works and is very stable. It is not a drop-in replacement, but it can do
most of the functions of SQLMail with a little extra work on your part.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:u$zN$SS4DHA.2332@.TK2MSFTNGP10.phx.gbl...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;313969
I don't get those errors from SQL Server. I get an error from Microsoft
Outlook 2003 that 'the folders cannot be created' if I allow SQL Server
Agent to start at boot in Windows 2000 SP3 and then try to open Microsoft
Outlook 2003. We have to use the same profile in SQL Mail as we use in
Microsoft Outlook 2003 because if we don't the SQL Mail will never be sent.
Therefore SQL Mail and Microsoft Outlook 2003 are both using the same pst.
Hmmm...
If SQL Server Agent starts at boot ( a little problem here) then Microsoft
Outlook 2003 will not start. So don't allow SQL Server Agent to start at
boot and use a different profile for SQL Mail then I use to start Microsoft
Outlook 2003. Then SQL Mail will not be able to send the mail until I close
down Microsoft Outlook 2003 in my main profile and open it in the profile I
have SQL Mail set to. But of course I also have to close down SQL Server
Agent to do this. Man what a humdinger.
--
George Hester
__________________________________|||I had similar problems with OutlookXP & it not being able to send mail
messages unless the pst file was open. I solved this by installing Outlook
2000 on the Server, which I believe SQL Mail was originally designed for.
Since then it was worked perfectly...
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hi Geoff. Oh I have that and it works great. But my issue still =exists.
-- George Hester
__________________________________
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message =news:#R5NxDT4DHA.1504@.TK2MSFTNGP12.phx.gbl...
> Try xp_smtp_sendmail from www.sqldev.net.
> > It works and is very stable. It is not a drop-in replacement, but it =can do
> most of the functions of SQLMail with a little extra work on your =part.
> > -- > Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> > > > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:u$zN$SS4DHA.2332@.TK2MSFTNGP10.phx.gbl...
> http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;313969
> > I don't get those errors from SQL Server. I get an error from =Microsoft
> Outlook 2003 that 'the folders cannot be created' if I allow SQL =Server
> Agent to start at boot in Windows 2000 SP3 and then try to open =Microsoft
> Outlook 2003. We have to use the same profile in SQL Mail as we use =in
> Microsoft Outlook 2003 because if we don't the SQL Mail will never be =sent.
> Therefore SQL Mail and Microsoft Outlook 2003 are both using the same =pst.
> > Hmmm...
> > If SQL Server Agent starts at boot ( a little problem here) then =Microsoft
> Outlook 2003 will not start. So don't allow SQL Server Agent to start =at
> boot and use a different profile for SQL Mail then I use to start =Microsoft
> Outlook 2003. Then SQL Mail will not be able to send the mail until I =close
> down Microsoft Outlook 2003 in my main profile and open it in the =profile I
> have SQL Mail set to. But of course I also have to close down SQL =Server
> Agent to do this. Man what a humdinger.
> > -- > George Hester
> __________________________________
> >|||Yes James. That is what I am seeing too.
-- George Hester
__________________________________
"James Goodman" <j a m e s@.norton-associates.co.u k> wrote in message =news:buqp6h$ppe$1@.hercules.btinternet.com...
> I had similar problems with OutlookXP & it not being able to send mail
> messages unless the pst file was open. I solved this by installing =Outlook
> 2000 on the Server, which I believe SQL Mail was originally designed =for.
> Since then it was worked perfectly...
> > > > -- > Cheers,
> > James Goodman MCSE, MCDBA
> http://www.angelfire.com/sports/f1pictures
> >