December 17, 2004 at 1:44 pm
Is there a sure way to make sure SQL Server never accepts any incoming mail?
Gregory A. Larsen, MVP
December 20, 2004 at 2:02 am
If you mean through exchange for example then I believe the mail account can be set to ignore incoming email.
If you mean the xp_xxxxxx mail procs then either remove them or explicitly deny access.
For an outlook client you can set the properties to delete all incoming mail, setting at the server is best.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 20, 2004 at 10:33 am
Actually I want to use POP3 and SMTP mail to support our servers. I want to be able to use xp_sendmail only. I suppose I can deny access to all the other xp_xxxxx procedures that process mail. Althought can I really deny access to all users? How do you keep users that have sysadmin rights from processing say xp_readmail?
Gregory A. Larsen, MVP
December 21, 2004 at 2:00 am
Technically you could never stop a sysadmin. I'd probably drop the procs if I were that worried about it or remove the sysadmin users.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 22, 2004 at 12:12 pm
Thank you for all your advice. I think I am just going to implement a SMTP solution, since our security and admin staff are concerned about POP3.
Gregory A. Larsen, MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply