Problem with delegation from ASP.NET to SQL

K

Kelly D. Jones

I'm having a problem retrieving data from our SQL server.

Here's the scenerio:
SQL Server 2000 running on Windows 2000
ASP.NET/IIS 6 (in IIS 6 process mode) running on Win2k3
the client is WinXP/IE 6

All of the machines are in one Active Directory Domain. The user
account is set to allow delegation (the "account is sensitive" is NOT
checked).

The process account that ASP.NET runs as (Domain\Test) is set with
"Trusted for Delegation" turned on.

Impersonation is turned on in the web.config file.

I set up a test page that displays the current security context
(System.Security.Principal.WindowsIdentity.GetCurrent().Name ), which is
the name of the user account I am logged in as.

When I try to fill a datagrid with SQL data, I get the following error:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Staff online

Members online

Forum statistics

Threads
473,769
Messages
2,569,577
Members
45,052
Latest member
LucyCarper

Latest Threads

Top