>This issue has nothing to do with the setting of RESOURCE (I was just giving it as an example of the problem with accessing the drive). The issue has something to do with how Server 2008 restricts application running on the server from writing to the drive.

What exactly does your application need to write on the server?