Re: Cannot setup SQL Mail on SBS 2003

Hi Mark,

I am sorry for the delayed response due to weekend. Please understand that
the newsgroups are staffed weekdays by Microsoft Support professionals to
answer your systems and applications questions. Your understanding is
greatly appreciated!

Thanks for your update! Yes, Outlook is not recommended to install in SBS
server since Exchange server has intalled on the box. If so, there are some
issues on it.

However if you want to configure SQL to send mail you need to install
Outlook to send mail. The SQL Mail feature of SQL Server 2000 does not work
if Microsoft Outlook is not installed on the server that functions as the
mail client. If you want to user SQL mail feature you must install it. I
have test it and it works properly.

I appreciate your understanding! If you have any further concern or question
on the issue, please feel free to let me know. I am always happy to be
assistance of 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.
----------------------------------------------------------------------------------
"Mark Stables" <MarkStables@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F1E8569-0D24-4D7A-8C86-4FC5CF04295D@xxxxxxxxxxxxxxxx
> HI Jenny,...
>
> Thanks for the input,.... we strike our first problem at step 1... We
> CANNOT install outlook on the Server computer because this is a Small
> Business Server we are talking about - ie: Exchange also on this box, and
> cannot install outlook on the exchange server!
>
> soo.... are we still stuck?
>
> Mark
>
>
> "Jenny wu [MSFT]" wrote:
>
>> Hi Mark and Karl,
>>
>> Thanks for posting here! Also thanks for Steve's input.
>>
>> To resolve SQL Mail issue, I suggest you double check your configuration
>> for
>> correcting an improper configuration can resolve the vast majority of SQL
>> Mail problems.
>>
>> To make sure that you have SQL Mail configured correctly, use this list:
>>
>> 1. You must have a mail client (such as Microsoft Outlook) installed on
>> the
>> computer that runs SQL Server.
>>
>> 2. Use the Corporate or Workgroup option for Microsoft Outlook 2000
>> (Microsoft Outlook 2002 does not have the Corporate or Workgroup option).
>> To
>> select the option, on the Tools menu, click Options, and then
>> double-click
>> the Mail Services tab. In the Mail Services dialog box, click the Mail
>> Support command. Microsoft Outlook 2002 does not work with SQL Mail when
>> you
>> use an Internet mail server unless the Outlook client is left running at
>> all
>> times.
>>
>> 3. You must have a working mail server such as Microsoft Exchange or an
>> Internet mail (Post Office Protocol 3 [POP3] or Simple Mail Transport
>> Protocol [SMTP]) server. The outgoing mail SMTP server need not be the
>> same
>> as the incoming mail POP3 server; however, you must have a valid incoming
>> mail server with a configured mail account, even if you never plan to
>> send
>> mail to SQL Mail.
>>
>> 4. The account you use to start the SQL Server service must be a domain
>> account if you are using an Exchange server. The domain account must have
>> a
>> mailbox on the Exchange server. If you are using an Internet mail server,
>> you can use a local account to start SQL Server. However, the account you
>> use to start SQL Server cannot be the Local System account, under any
>> circumstances. The same applies to the service account you use to start
>> the
>> SQL Agent if you are using SQLAgentMail.
>>
>> 5. Because mail profiles are associated with a Microsoft Windows login
>> account, you must log on to the computer that is running SQL Server with
>> the
>> SQL Server service startup account in order to inspect the mail profile
>> available to SQL Server. For example, open Control Panel. In the Control
>> Panel dialog box, double-click Mail. In the Mail dialog box, double-click
>> Show Profiles. If you are using SQLAgentMail and the SQL Agent service
>> account is different from the SQL Server service account, you must also
>> log
>> on with the SQL Agent service startup account to inspect the mail
>> profiles
>> available to the SQL Agent.
>>
>> 6. You must be able to open the mail client and test sending and
>> receiving
>> an e-mail to your mail server. No dialog box or message should appear
>> that
>> requires user action. SQL Mail uses the mail client to send mail. Because
>> SQL Mail runs in the SQL Server service, any dialog boxes that require
>> user
>> interaction appear on the "virtual desktop" and do not receive a
>> response.
>> The lack of response causes SQL Mail to stop responding (hang).
>>
>> 7. You must provide SQL Mail the mail profile you use to test your mail
>> client configuration. To do so, in Enterprise Manger, open the Support
>> Services folder. In the Support Services folder, right-click SQL Mail,
>> and
>> then click Properties. If you use SQLAgentMail, you must provide the mail
>> profile to SQL Agent. To do so, in Enterprise Manager, open the
>> Management
>> folder, right-click SQL Agent, and then click Properties.
>>
>> 8. The default Internet e-mail program must be the same as the mail
>> client
>> you use to test the mail configuration. To make sure you have the correct
>> program, open Control Panel, double-click Internet Options, and then
>> click
>> the Programs tab.
>>
>> 9. For any of the preceding changes to take effect, you must stop, and
>> then
>> restart the SQL Server service. If you reconfigure the default mail
>> profile,
>> you must restart the computer for the changes to take effect.
>>
>> And I would like to suggest you refer to the following KB article to get
>> more detail info about frequently encountered problems and general
>> troubleshooting methods.
>>
>> 315886 INF: Common SQL Mail Problems
>> http://support.microsoft.com/kb/315886/en-us
>>
>> 311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
>> http://support.microsoft.com/kb/311231/EN-US/
>>
>> HOW TO: Troubleshoot Your SQL Mail Issue (321183)
>> http://support.microsoft.com/kb/321183/EN-US/
>>
>>
>> The following KB article may be useful to you:
>>
>> How to obtain the latest SQL Server 2000 service pack
>> http://support.microsoft.com/default.aspx?scid=KB;EN-US;290211
>>
>> INF: How to Configure SQL Mail
>> http://support.microsoft.com/kb/263556/en-us
>>
>> FIX: SQL Agent Mail May Cause E-mail to Be Written to Root Directory of
>> Source Mailbox (308758)
>> http://support.microsoft.com/kb/308758/en-us
>>
>> Support WebCast: Troubleshooting Microsoft SQL Mail
>> http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/wc091301/wcblurb091301.asp
>>
>> Hope above information helps! If you have any further concern or question
>> about the issue please feel free to let me know. I am always happy to be
>> assistance of you!
>>
>> Have a nice weekend!
>>
>> 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.
>> ----------------------------------------------------------------------------
>> -----
>> <shiftylizzards@xxxxxxxxx> ????
>> news:1125072703.078521.29790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > Thanks anyways Steve. Been searching the KB, but as you said, 'experts
>> > at hiding...'!
>> >
>> > Good weekend! ;-)
>> > K
>> >
>>
>>
>>


.

Relevant Pages

  • RE: Backups, VSS and SBS2003 HELP NEEDED!!!
    ... 2K3 server currently, also, I understand that it is better to have a backup ... Support Professional can assist with your request. ... Microsoft CSS Online Newsgroup Support ... >> suggest customers Only install Windows Server 2003 SP1 on their server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Sharpoint Error in SBS 2003
    ... Have you upgraded the Sharepoint WMSDE to SQL server? ... A supported hotfix is now available from Microsoft, ... contact Microsoft Product Support ... Please paste all the accurate errors information in the newsgroup. ...
    (microsoft.public.windows.server.sbs)
  • RE: Critical error in application log SBS 2003 Premium ED
    ... please contact PSS and apply the hotfix on your server. ... Microsoft CSS Online Newsgroup Support ... When opening a new thread via the web interface, we recommend you check the ...
    (microsoft.public.windows.server.sbs)
  • RE: Server cant be seen from the network
    ... Microsoft CSS Online Newsgroup Support ... I discovered that if I turned the SQL server ... NAT issues caused with the installation of the "full" SQL ...
    (microsoft.public.windows.server.sbs)
  • RE: Problems connecting to desktops through RWW
    ... "The drive contains a disc for Windows Small Business Server 2003 with no ... I'd like to suggest that you contact Microsoft Customer Support Service by ... which offering (newsgroup, chat, email, phone, etc) is selected. ... Microsoft Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)