Wednesday, March 28, 2012

Outlook and SQL2000

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 co
mprimised through Outlook.
Does anyone have any thoughts on this? I tried another program STMPT but fou
nd it hard to setup and use. Basically it I can no longer use the alerts I c
reated in SQL.We use XP_SMTP_SendMail
http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"robert_at_cbb" <robertatcbb@.discussions.microsoft.com> wrote in message
news:8DBF7620-3465-430C-B0B2-A1E48F755C97@.microsoft.com...
> 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.|||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.
|||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 cre
ating 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:
>|||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:[vbcol=seagreen]
> Mark,
> One of the issues I had on installing outlook on my servers is that some o
f them are local accounts only. HOw would I go about using outlook without c
reating a domain local admin from being logged in all the time?
> "Mark Allison" 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 de
scribe a way to create a mapi profile without installing outlook. Can I use
this? I run sql2000 on a wi
n2000 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 u
p.
> 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:
>|||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 domai
n account if I use exchange which I do. Then the article went on to describe a way t
o create a mapi profile without installing outlook. Can I use this? I run sql2000 on
a
win2000 server.[vbcol=seagreen]
> "Mark Allison" wrote:
>

No comments:

Post a Comment