Re: SqlXml Bulk Load Error: COMException (0x80004005)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm no expert in this area, but I've seen similar symptoms to what you
describe that were resolved by setting the "Trusted for Delegation" group
policy setting. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/gp/538.asp.

Of course, it might be completely unrelated - sorry not to be more definite!

--
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com


"LvBohemian" <LvBohemian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CDFC776F-6F83-40AF-A3E2-7D11D7CDB3D6@xxxxxxxxxxxxxxxx
Neither the IIS Computer itself nor the account it is using are setup for
any
specific delegation, I created an Service account which has log on as a
service and a batch job for the domain that both the sql server & web server
are on, gave that account access to the applicable database from within sql
server. In the web config of the web app I am using the identity tag thus:
<identity impersonate="true" userName="domain\account" password="password"/>
for proof of concept once working then I will go with the encrypted version
using aspnet_setreg.exe:
<identity>
userName="registry:HKLM\Software\AspNetIdentity,Name"
password="registry:HKLM\Software\AspNetIdentity,Pwd"
</identity>

If I use same account on a box with both a web server and a sql server on it
it works...

What delegation rights do you think the web server & or account it is using
might need?

Thanks in advance.


.

Relevant Pages

  • Re: CA web component problems
    ... Could you please confirm that the Enterprise Admin account you are using is ... > for delegation via the ADUC check box. ... is there a way to install the Web enrollment pages ... >>> enabled the web server for delegation via ADUC and rebooted the ...
    (microsoft.public.win2000.security)
  • Re: Windows integrated authentication with site content on UNC share...
    ... I have configured the AD such that the web server and the ... checkbox for "Trust computer for delegation". ... right clicking on the user account, went to "Account" tab and enabled ... Client Realm: ...
    (microsoft.public.inetserver.iis.security)
  • Re: Windows (Trusted) Authentication and SQL Server
    ... The account whose credentials are being delegated must be a domain account ... The computer on which the delegation takes place ... Server) does not need to be marked as trusted. ... in to play is when an IE client connects to a web server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: accessing Active Directory
    ... I find the document and tried to apply the delegation in the active directory ... then I made the web server computer to be trusted for delegation ... then you can use a service account instead. ...
    (microsoft.public.dotnet.security)
  • RE: How to enable IWA over multiple servers
    ... Boot up computer and logon as ActiveDirectory username (im joe ... a member of 192.168.0.4 (the web server), ... through a local account on the webserver rather than a domain user ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)