RE: Required permissions cannot be acquired.

1 Aug 2006 11:23 AM

squatss

Hi Peeps,

I have an issue with "Required permissions cannot be acquired"
exception.

The scenario is as follows:

I have a c# console app that sits on our database server. The console
app is to scheduled by a SQL Server DTS Job to run hourly and process
batches.

The app calls a web service to make automated credit card transactions.

The logged on user to the machine is a domain utility account called
AdminTool. If I schedule the Console app using windows sheduled tasks,
the app works fine.

If I schedule the app using dts, the app fails citing the Required
permissions cannot be acquired. exception.

The dts job is run under the context of the SQL Server Agent account
which is a network SQL Admin Account called zSQLExec.

zSQLExec invokes the Console app as Admin tool but the app failes with
the above mentioned error.

I have loooked at numerous posts on tinternet that say that I need to
grant full trust to the assemblies in the app which I have done but it
still fails.

Any help would be most appreciated.

Cheers

Scott

1 Aug 2006 11:34 AM

Nicole Calinoiu

Could you please post the full exception details (including call stack
listing), as returned by its ToString method? Also, when you run the
application from DTS, what path are you using to invoke it?

<squa***@hotmail.com> wrote in message
Show quoteHide quote

news:1154431405.967834.6090@75g2000cwc.googlegroups.com...
> Hi Peeps,
>
> I have an issue with "Required permissions cannot be acquired"
> exception.
>
> The scenario is as follows:
>
> I have a c# console app that sits on our database server. The console
> app is to scheduled by a SQL Server DTS Job to run hourly and process
> batches.
>
> The app calls a web service to make automated credit card transactions.
>
> The logged on user to the machine is a domain utility account called
> AdminTool. If I schedule the Console app using windows sheduled tasks,
> the app works fine.
>
> If I schedule the app using dts, the app fails citing the Required
> permissions cannot be acquired. exception.
>
> The dts job is run under the context of the SQL Server Agent account
> which is a network SQL Admin Account called zSQLExec.
>
> zSQLExec invokes the Console app as Admin tool but the app failes with
> the above mentioned error.
>
> I have loooked at numerous posts on tinternet that say that I need to
> grant full trust to the assemblies in the app which I have done but it
> still fails.
>
> Any help would be most appreciated.
>
> Cheers
>
> Scott
>