Setting up FTP in Windows Server 2008

To set up the FTP site, follow these steps:

1. In User Manager, create a user account for each of your users.
   
   Note These users need to have the local log on permission. By default, new users belong to the built-in Users group, which has local log on permission.


2. Using the Windows NT Explorer, on a partition formatted with NTFS, give the FTP site's root folder the following security access types:
   
   
   
   • Administrators: Full Control
   
   
   • Everyone: Read
   
   
   • System: Read
   
   
   
   


3. Create a subfolder for each user. (These subfolders will inherit the root folder's security settings). Make the following security changes:
   
   
   
   • Remove the Everyone group.
   
   
   • Change the System account's folder's access to Full Control (instead of Read).
   
   
   • Add the user who will use that folder, and give that user Full Control access.
   
   
   
   


4. Configure the home page for the user. To do this, follow these steps:

1. In Control Panel, open Administrative Tools.


2. Double-click Computer Management.


3. Expand Local Users and Groups, click Users, right-click the user name, and then click Properties.


4. Click the Profile tab.


5. Make sure that Local path is selected under Home Folder, and then type the appropriate path in the Local path box. For example, type the path as d:\Ftp\FolderName.
   
   Note The user name and the folder name must match. For example, if the user name is JoeUser, the FolderName should also be JoeUser. If the folder name is different, the user will see the same view that is available to Anonymous users. This view is the complete parent folder structure. The user is still denied access to folders to which they are not specifically granted NTFS permissions. However, the parent folder view may be undesirable


6. Also Check to see FTP service is running.

How to: Configure SMTP mail server in Windows Server 2008 and IIS 6.0

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.