Re: Outlook and SQL2000

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 07/20/04


Date: Tue, 20 Jul 2004 11:11:48 +0100

robert_at_cbb,

I've never tried it without Outlook. Some people have and it works for
them, but I think it tends to be more problematic than having Outlook
installed.

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
robert_at_cbb wrote:
> Thank you Mark. I read a few of the articles and found that I need to have a domain account if I use exchange which I do. Then the article went on to describe a way to create a mapi profile without installing outlook. Can I use this? I run sql2000 on a win2000 server.
> 
> "Mark Allison" wrote:
> 
> 
>>robert_at_cbb ,
>>
>>That's my point, you don't need to be logged on when using MAPI (the 
>>Outlook client). See the articles below for information on how to set it up.
>>
>>INF: How to Configure SQL Mail
>>http://support.microsoft.com/?id=263556
>>
>>INF: Frequently Asked Questions - SQL Server - SQL Mail
>>http://support.microsoft.com/?id=311231
>>
>>INF: Common SQL Mail Problems
>>http://support.microsoft.com/?id=315886
>>
>>HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server
>>http://support.microsoft.com/?id=153159
>>
>>You've got mail - or have you?
>>http://www.allisonmitchell.com/Articles/mail.htm
>>
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>
>>robert_at_cbb wrote:
>>
>>>Mark,
>>>
>>>One of the issues I had on installing outlook on my servers is that some of them are local accounts only. HOw would I go about using outlook without creating a domain local admin from being logged in all the time?
>>>
>>>"Mark Allison" wrote:
>>>
>>>
>>>
>>>>robert_at_cbb,
>>>>
>>>>Well, outlook doesn't have to be running for you to be able to use 
>>>>SQLMail. The server will be logged off. If you restrict who can log on 
>>>>to the server console, and those people can be trusted not to abuse 
>>>>Outlook, then I can't see a problem.
>>>>--
>>>>Mark Allison, SQL Server MVP
>>>>http://www.markallison.co.uk
>>>>
>>>>Looking for a SQL Server replication book?
>>>>http://www.nwsu.com/0974973602.html
>>>>
>>>>
>>>>
>>>>robert_at_cbb wrote:
>>>>
>>>>
>>>>>I am having some issues with our security department in regards to having to have outlook on the SQL server. Basically their afraid the server can be comprimised through Outlook.
>>>>>
>>>>>Does anyone have any thoughts on this? I tried another program STMPT but found it hard to setup and use. Basically it I can no longer use the alerts I created in SQL.
>>>>


Relevant Pages

  • Re: Outlook and SQL2000
    ... How to Configure SQL Mail ... > Mark Allison, SQL Server MVP ... > Looking for a SQL Server replication book? ... >> One of the issues I had on installing outlook on my servers is that some of them are local accounts only. ...
    (microsoft.public.sqlserver.server)
  • Re: Configuring SQL Mail without Outlook
    ... Outlook is the only MAPI provider available. ... They are not drop-in replacements for SQL Mail, but can do most all of the ... I support the Professional Association for SQL Server ... > SQLAgentMail service) but does not want to install Outlook on the server. ...
    (microsoft.public.sqlserver.server)
  • PROBLEM WITH BCM AND SQL SERVER
    ... A problem with BCM started to occur on my computer recently. ... outlook I received an error message “BCM for Outlook could not connect to the ... When Trying To Start Sql server Through Computer Management I get ... about how to rebuild the master database, ...
    (microsoft.public.outlook)
  • Re: Application sending email
    ... Top Causes of SQL Server Downtime ... "Is it better to use a mail client that has no ... how can you secure Outlook... ... Package developers want to install Outlook on SQL server (has to ...
    (microsoft.public.sqlserver.security)
  • SQL Mail: Missing From Address
    ... I have a Win2K server configured with SQL Server 2k. ... I have a single profile created with a single POP account. ... I sit at the console and start up Outlook. ... Is this an Outlook configuration ...
    (microsoft.public.outlook)