Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Problem with delegation from ASP.NET to SQL

Thread Tools

Problem with delegation from ASP.NET to SQL

Kelly D. Jones
Posts: n/a
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

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.GetCurr ent().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:
Exception Details: System.Data.SqlClient.SqlException: Login failed for

Any suggestions will be greatly appreciated.
Kelly D. Jones

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
delegation question, where I want prototype style delegation Sam Roberts Ruby 4 05-07-2008 05:48 AM
custom code + delegation = problem... Jéjé ASP .Net 6 06-20-2005 05:13 PM
Problem with ASP.NET Delegation and Impersonation jm ASP .Net 1 12-20-2003 01:12 AM
Impersonation, Delegation & SQL Server Rob Edwards ASP .Net Security 2 11-28-2003 11:52 AM
Problem with impersonation and delegation Kelly D. Jones ASP .Net 1 09-12-2003 04:43 PM