Hi Oliver,
I tried a few ways to perform the impersonation based on Knowledge Base
article 306158, INFO: Implementing Impersonation in an ASP.NET Application.
One of the ways was to use settings in my web.config file similar to how
your show in your email.
The "System.Securit y.Principal.Win dowsIdentity.Ge tCurrent().Name " procedure
returns the domain and user account I am trying to impersonate for the
different ways I have tried impersonation, but the DTS Package that I issue
the .Execute method on does not actually execute the Package.
I doing further testing with Events enabled, I have found the following
error is getting logged:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Acc ess is denied.
(Microsoft Data Transformation Services (DTS) Package (80070005): Access is
denied.)
(Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on
'<servername>.< databasename>.L OG'. Access is denied.)
Step Error code: 80070005
Step Error Help File:sqldts80.h lp
Step Error Help Context ID:1100
I do not get this error when executing the DTS Package from a Windows Form
application, so the ASP.NET impersonation is different somehow from how my
Windows Form application.
I don't understand why I get the Access is denied error from ASP.NET when
the system says I am the same user account that works without any error from
my Windows program.
Hopefully someone can help provide information to resolve this problem ...
Thanks,
Dean
"Oliver" <DE************ *******@hotmail .com> wrote in message
news:Ol******** ******@tk2msftn gp13.phx.gbl...
Just checking but have you set the web.config for your Web service to use
impersonation?
<configuratio n>
<system.web>
<identity impersonate="tr ue"/>
</system.web>
</configuration>
<configuratio n>
<system.web>
<identity>
userName="regis try:HKLM\Softwa re\AspNetIdenti ty,Name"
password="regis try:HKLM\Softwa re\AspNetIdenti ty,Pwd"
</identity>
</system.web>
</configuration>
"Dean R. Henderson" <de**@ifmail.co m> wrote in message
news:O7******** *****@TK2MSFTNG P12.phx.gbl... I have a DTS Package I am able to execute successfully from a Windows
Form application, but I cannot get this to work from an ASP.NET Web Service,
although the Web Service impersonates the same user the Windows Form
runs under.
When I run the Web Service, I make a call to
"System.Securit y.Principal.Win dowsIdentity.Ge tCurrent().Name " and this
verifies the user-id is the same account I am logged onto when I
successfully run my Windows Form application.
Both the Web Service and the Windows Form do the same setup and call the
DTS.Package.Loa dFromSQLServer method with the same parameter values.
No error is returned when trying to execute the DTS Package from the
ASP.NET Web Service, but the DTS Package does not get executed.
The account that Aspnet_wp.exe runs under has been granted "Act as part
of the operating system" privilege, so it is able to impersonate the user
account the Windows Form is using, but is there some other privilege
needed so it can execute the DTS Package?
Thanks,
Dean
