glgcag1991
Programmer
I'm using SQL Server 2005 and I have an Exchange 2003 server on my network that I administer as well.
In setting up the DB Mail I noted the options for the smtp account authentication are "Windows authentication using database engine service credentials", "Basic Authentication" or "Anonymous Authentication".
Since I have a separate domain user account for my SQL Server service, I mail-enabled it and I'm using it as my SQL Server mail account. I did this because I prefer using Windows auth whenever I can, and in the setup there are no options to use Windows auth for other accounts than the db engine service account.
Is this a best practice or should I just use the "Basic Authentication" with whatever account I want?
Also, the only use I currently have for DB Mail is maintenance notifications for jobs I have set up. Therefore, I set up only one profile, made it public and the default- I haven't created any other profiles. As far as I've read this is pretty typical unless there are non-maintenance mail needs. Does this pose any security risks or problems down the road?
Thanks for the help!
In setting up the DB Mail I noted the options for the smtp account authentication are "Windows authentication using database engine service credentials", "Basic Authentication" or "Anonymous Authentication".
Since I have a separate domain user account for my SQL Server service, I mail-enabled it and I'm using it as my SQL Server mail account. I did this because I prefer using Windows auth whenever I can, and in the setup there are no options to use Windows auth for other accounts than the db engine service account.
Is this a best practice or should I just use the "Basic Authentication" with whatever account I want?
Also, the only use I currently have for DB Mail is maintenance notifications for jobs I have set up. Therefore, I set up only one profile, made it public and the default- I haven't created any other profiles. As far as I've read this is pretty typical unless there are non-maintenance mail needs. Does this pose any security risks or problems down the road?
Thanks for the help!
