Some time back, I had a problem with exporting huge amount of data as csv to view in excel from a production server. It took several minutes when the server load was normal and far worse when it experienced peak traffic. My client asked me if I could take this feature off of the live server and then automate this process so that he would receive the exported data in the mail instead of requesting data from me. This meant three things, creating a sql job that executed once a week which executed an export script using ‘bcp’ feature to a file which would then be sent as an attachment to the client. I will explain how to configure SMPT mail server and send email as a two part series.
This is the first of the two part series where I would like to show how to configure SMTP mail server in Windows Server 2008.
- From the Start Menu, navigate to “Administrative Tools” and select “Server Manager”.
- From the “Features Summary” click on “Add Features”.
- Select “SMTP Server” and click on Install. Accept all changes.
- Now from “Administrative Toos” , select “Internet Information Services (IIS) 6.0 Manager”.
- Right click on “SMTP Virtual Severs” and click on properties.
- Navigate to “Access” tab and click on “Relay” button.
- Leave the “Only the list below” radio button clicked and click on “Add” button.
- Leave the “Single computer” option selecte and enter 127.0.0.1 as your IP address.
- Now click apply and you are almost done.
- Right click on “SMTP Virtual Severs” and click on start.
This is it. Now you have SMPT server configured and running!! Follow the next part in this two part series to send mail via SQL Server 2008 Enterprise Edition.