View Single Post
  #11 (permalink)  
Old April 30th, 2004, 08:19 AM
chiefg chiefg is offline
Authorized User
 
Join Date: Dec 2003
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am trying to dump data from SQL Server into an Excel file. I want to dump the file to the web server and have the user retrieve it via one of our web apps. Of course, in order to have the DTS package dump the data to the server, the SQL Server Service Account needs permission to access the erver. What is the best way to give SQL Server that permission. Is it just by right clicking on the folder and selecting Property, the clicking the Security tab?