hi all,

I have a asp.net calling an integration service package. it runs fine in my
dev box, but as soon as I deploy it to the prod server, it throw up with an
exception saying "dts exception: failed to connect to server "SQL1" : access
denied."

but I log into the prod server and create a package in that box and it runs
fine in the vs.net IDE connecting to SQL1.

am I missing any security check here?

Kevin