Re: Cannot setup SQL Mail on SBS 2003
- From: v-yanniw@xxxxxxxxxxxxxxxxxxxx ("Jenny wu [MSFT]")
- Date: Tue, 09 Aug 2005 08:39:53 GMT
Hi Nicolas,
Thanks for posting here! Many thanks to Steve's input!
Steve's answer is accurate. What is more, I would like to give you some
information about the issue:
To configure SQL Server to send email on Small Business Server, we can use
"newprof -p .\sbs.prf" command to create a new email profile. With this
profile, you will be able to send SQLMail from this server.
For more information, please refer to the following Microsoft Knowledge
Base article:
304967 How to Configure SQL Server to Send Email on Small Business Server
2000
http://support.microsoft.com/?id=304967
How to install SQL Mail (263556) http://support.microsoft.com/kb/263556/
306962 How to create MAPI profiles without installing Outlook
http://support.microsoft.com/kb/306962/
Microsoft does not support installing Exchange Server components and
Outlook on the same computer
http://support.microsoft.com/kb/266418/
HOW TO: Troubleshoot Your SQL Mail Issue:
http://support.microsoft.com/kb/321183/
Frequently asked questions - SQL Server - SQL Mail:
http://support.microsoft.com/kb/311231/
INF: Common SQL Mail Problems: http://support.microsoft.com/kb/315886/
If you have any further concern or question about the issue please feel
free to let me know. We are happy to be further assistance. I am looking
forward to you!
Have a nice day!
Best Regards,
Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "Steve Foster [SBS MVP]" <steve.foster@xxxxxxxxxxxxx>
>Subject: Re: Cannot setup SQL Mail on SBS 2003
>References: <42f7d1fc$0$22199$39cecf19@xxxxxxxxxxxxxxxxxx>
>Organization: Picamar Limited
>User-Agent: XanaNews/1.17.5.7
>Message-ID: <xn0e5s282fajwhp02r@xxxxxxxxxxxxxxxxxxxx>
>X-Ref: msnews.microsoft.com ~XNS:00001164
>MIME-Version: 1.0
>Content-Type: text/plain; charset=utf-8; format=flowed
>Newsgroups:
microsoft.public.sqlserver.server,microsoft.public.windows.server.sbs
>Date: Mon, 08 Aug 2005 18:58:06 -0700
>NNTP-Posting-Host: dsl-212-135-222-181.dsl.easynet.co.uk 212.135.222.181
>Lines: 1
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:142569
microsoft.public.sqlserver.server:66259
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Nicolas Verhaeghe wrote:
>
>>I have SQL Server 2000 setup on a SBS 2003 Premium server, with Exchange
>>2003.
>>
>>I set up SQL Mail to use the only profile available, which is
>>"ExchangeAdmin SBS (0x codes following)".
>
>Hmmm, not sure where that's from, since SBS normally has no MAPI profiles
>at all by default.
>
>Have you configured SQL Server and all associated services to run under a
>user account, rather than LocalSystem (the default)?
>
>>When I try a simple xp_sendmail to an existing email address, I get the
>>following:
>>xp_sendmail: failed with mail error 0x80004005
>>
>>When I search Microsoft.com, or all of the Web, I see that there is a
>>workaround specified by Microsoft:
>>
>>http://support.microsoft.com/kb/293422/EN-US/
>>
>>The problem is that I cannot "Locate the user object directly associated
>>with the Exchange 2000 mailbox". First of, I have Exchange 2003, not
2000.
>>Second, I cannot find the specified "ExchangeAdmin SBS ..." account.
>
>It's not an account, it's a MAPI profile belonging to a user account. MAPI
>profiles belong to user accounts, and can only be accessed and manipulated
>by the user account they belong to.
>
>>
>>I also tried installing Outlook, creating a profile with a user called
>>"SQLEmailAccount", so that I could locate it in AD and apply the
>>workaround, but when I open Enterprise manager, and try to select this
>>email profile for SQL Mail (as described at the top of this email), it
>>simply does not appear...
>
>AARGH. Get Outlook *OFF* your SBS as fast as possible. Outlook is *not*
>supported for installation on an Exchange Server (like SBS).
>
>>
>>It seems that I can nonetheless use a workaround, as I found a few SPs
>>which create a CDO object (a bit like what you would do in ASP) and talk
>>to it, but I'd like to be able to use xp_sendmail in order to allow
>>contractors to use standard programming techniques.
>
>
>The KB articles you need are:
>
>304967 How to Configure SQL Server to Send Email on SBS 2000
>http://support.microsoft.com/?id=304967
>
>
>and
>
>228736 SAMPLE Profman2.exe - MAPI Profile Manager v2.0
>http://support.microsoft.com/?id=228736
>
>While the first article says SBS2000, it applies equally to SBS2003. But
>creating the MAPI profile is much easier to do with PROFMAN (from the
>second KB) than all the registry hacking the first article suggests you do.
>
>
>--
>Steve Foster [SBS MVP]
>---------------------------------------
>MVPs do not work for Microsoft. Please reply only to the newsgroups.
>
.
- Follow-Ups:
- Re: Cannot setup SQL Mail on SBS 2003
- From: Oscar
- Re: Cannot setup SQL Mail on SBS 2003
- Prev by Date: Re: Problem installing SBS2003 on MSI 915P motherboard with SATA R
- Next by Date: Re: Free Google for Desktops!
- Previous by thread: Re: Folders and Directory
- Next by thread: Re: Cannot setup SQL Mail on SBS 2003
- Index(es):
Relevant Pages
|
