Post reply

permissions problem running dts from asp.net

  • January 25, 2006 at 8:59 am

    #166797

    I have an c# asp.net application that runs a dts package. The package gets some data from an sql server table and writes it to a file on the hard disk. I added the aspnet account to sql server and added it to the relevant database. When I run the application the file is not created and no error is returned. When I give the aspnet account, system administrators role with sql server it works fine. What do I need to do?

     

    Thanks

    Danny

  • January 25, 2006 at 9:15 am

    #616940

    I think the account will also need access to msdb as this is where the packages are contained in terms of system tables.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • January 25, 2006 at 9:45 am

    #616958

    I made the aspnet the owner of msdb to test it, but still did not work unless a member of the system administrators role.

    Thanks

    Danny

  • January 25, 2006 at 10:03 am

    #616967

    Danny,

    What permissions did you give the aspnet account in the source database?  Does the account have permission to write to the disk location where the destination file is to be created?  Enable package logging to get an idea of what is happening when the package executes.

    Greg

    Greg

  • January 26, 2006 at 2:52 am

    #617095

    Greg,

    Thanks. Enabling the package logs revealed a permissions error reading an sql table with the asp.net account.

    Thanks again

    Danny

     

  • January 26, 2006 at 8:54 am

    #617205

    Glad to help.  I can't even think how many times logging has helped me figure out a problem in a package.

    Greg

    Greg

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply