"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:d50rl0dd4of54b6g50r8aq46cdu2q39mep@4ax.com...
> You have to google to find the hotfix. I know a hotfix number was
> posted at some point in the SQL Server newsgroups.
> No it's not true that if the accounts are different you could not
> execute xp_sendmail. Being able to use xp_sendmail means SQL Mail is
> set up correctly. Your issue is with the mail profile for Agent. SQL
> Mail and SQLAgentMail are two separate things with different
> configurations. So being able to use xp_sendmail but not being able to
> select a profile for mail indicates that the issue is with
> SQLAgentMai. That's all.
> I understand that you need to have outlook and exchange on the same
> box. With Exchange 2003, there were initially some issues with the
> Simple MAPI entry points in the MAPI32 that's shipped with Exchange
> 2003. That's what there was at fix for at some point. I don't know if
> this was addressed in a service pack or not.
> But...all that being said, you may want to consider using smtp mail
> instead and just get away from the whole MAPI nightmare. There are
> plenty of people who no longer use MAPI and SQL Mail or SQLAgentMail
> due to all of the headaches with MAPI. You can download an extended
> stored procedure that many people have been using to send mail using
> smtp. I hate the MAPI issues and have used this instead of SQL Mail
> and SQLAgentMail at most client sites for the past two and a half
> years. You can find the download and more information at:
> http://www.sqldev.net/xp/xpsmtp.htm
> Some people have gotten all of the mail capabilities to work under
> your circumstances but I'd guess there is some odd issue as there are
> quite a few posts of people struggling to get that configuration to
> work. That's why I'd really suggest trying the smtp mail instead.
>
> -Sue
>
> On Fri, 1 Oct 2004 09:54:02 -0400, "Joe Bucar" <jbucar@hotmail.com>
> wrote:
>
> >Once again Thank You for your time in responding to my problem. I did
find
> >comments on the internet about re-booting the server and tried it but I
> >still have the same problem. I also searched Microsoft and the Web about
> >the hotfix and did not find any information about the problem. I do not
> >know how to prove that I am using the same account for SQL Server and SQL
> >Agent I tried to send a couple of bmp's but that made for a oversized
e-mail
> >and was rejected. I have successfully accomplished this on a SBS 2000
box
> >in the past. Is it a true statement that if the accounts are different I
> >could not execute xp_sendmail in SQL Query Analyzer? I can do
xp_sendmail
> >in Query Analyzer and that is why I beleive that I have it set up OK. As
> >far as outlook and exchange on the same box what other choice do I have?
I
> >am using the Administrator account for both.
> >
> >Joe
> >
> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> >news:2jbpl05n7v1ckjjk7rh5349uhgoi83hnj6@4ax.com...
> >> If the configurations are exactly as they need to be, a
> >> couple of people have fixed the problem with the same SBS,
> >> SQL, Exchange setup by just rebooting the server.
> >> Additionally, there is or was an issue with Exchange 2003
> >> and Outlook being installed on the same box. There is or was
> >> a hotfix for this.
> >> You still need to make sure the SQL Server and SQL Agent
> >> accounts are domain accounts and that this is the acount you
> >> are using when you log on and create the mail profile. Are
> >> the accounts the same for SQL Server and SQL Agent?
> >>
> >> -Sue
> >>
> >> On Thu, 30 Sep 2004 15:52:17 -0400, "Joe Bucar"
> >> <jbucar@hotmail.com> wrote:
> >>
> >> >Thank You for your reply and the links but I have already reviewed
them
> >and
> >> >I beleive I have done everything in the links and I still have the
same
> >> >problem. I beleive the account I set up is good because I can use
> >> >xp_startmail, xp_sendmail, and xp_stopmail in Query analyzer.
> >> >
> >> >Joe
> >> >
> >> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> >> >news:bkbol094hpcfuqa0okbe5pj4u60h493pgu@4ax.com...
> >> >> Log onto the server using the service account used to start SQL
Server
> >> >> and SQL Server agent. Then set up the mail profile while logged in
> >> >> under this account.
> >> >> You may also want to refer to the following articles:
> >> >> INF: How to Configure SQL Mail
> >> >> http://support.microsoft.com/?id=263556
> >> >> INF: Common SQL Mail Problems
> >> >> http://support.microsoft.com/?id=315886
> >> >>
> >> >> -Sue
> >> >>
> >> >> On Thu, 30 Sep 2004 08:35:07 -0700, Joe Bucar
> >> >> <JoeBucar@discussions.microsoft.com> wrote:
> >> >>
> >> >> >Hello,
> >> >> >I have a Server with SBS 2003, Exchange 2003, SQL 2000 and Outlook
> >2003
> >> >all
> >> >> >with current service packs. I am having a problem with SQL Mail.
The
> >> >problem
> >> >> >is the mail profile is grayed out in SQLServerAgent and I do not
know
> >> >why.
> >> >> >
> >> >> >I created a mail profile on the server in exchange that I called
> >SQLMail.
> >> >I
> >> >> >then opened SQL Enterprise Manager went to Support Service and then
to
> >> >SQL
> >> >> >Mail, I opened the drop down box and selected the profile that I
> >created
> >> >> >called SQLMail and then clicked the "Test" button and the message
that
> >> >came
> >> >> >back was "Successfully stopped and started a MAPI Session". I then
> >went
> >> >to
> >> >> >SQLServerAgent properties and notice that Mail profile is grayed
out
> >so I
> >> >can
> >> >> >not
> >> >> >at this point create Operators under SQL Server Agent. Since
Exchange
> >and
> >> >> >SQL is on the SBS server, the user I am using is Administrator and
I
> >used
> >> >> >Administrator in SQL and Exchange. The problem looks to me as if I
am
> >> >not
> >> >> >somehow using the same domain account for exchange and SQL but from
> >what
> >> >I
> >> >> >can see I am using the same account. Also, I am able to start, stop
> >and
> >> >send
> >> >> >mail through SQL's Query Manager.
> >> >> >Thanks,
> >> >> >Joe
> >> >>
> >> >
> >>
> >
> >
> >
> >
>