Hello,
I am having trouble with SQL Server 2005 logins and delegation from a
Workflow applicatio called via an ASP.NET app.
Here is a detailed account of my setup:
My IIS server 6.0 is on a different machine than my SQL Server, but they are
on the same domain.
Both machines are running Server 2003.
I'm using .NET 3.5.
In IIS the application has anonymous users allowed, but the anonymous user
is a domain user with db_owner role status set on the SQL database.
For the heck of it I gave the domain user domain admin.
Here is my web.config http://pastebin.com/m74527569
In my VS 2008 solution, the ASP.NET app is a seperate project from the
Workflow project.
The IIS server machine has allow delegation enabled on the domain controller.
In my ASP.NET app I have this line:
SqlWorkflowPers istenceService persistenceServ ice = new
SqlWorkflowPers istenceService( "Server=DBSERVE R;Database=WWFP ersistence;Trus ted_Connection= yes;");
And when I run the ASP.NET app I get this error:
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: Login failed for user
'NT AUTHORITY\ANONY MOUS LOGON'.
The entire error is here http://pastebin.com/m70c890db
Does anyone know what might be the cause of this headache?
Casey
I am having trouble with SQL Server 2005 logins and delegation from a
Workflow applicatio called via an ASP.NET app.
Here is a detailed account of my setup:
My IIS server 6.0 is on a different machine than my SQL Server, but they are
on the same domain.
Both machines are running Server 2003.
I'm using .NET 3.5.
In IIS the application has anonymous users allowed, but the anonymous user
is a domain user with db_owner role status set on the SQL database.
For the heck of it I gave the domain user domain admin.
Here is my web.config http://pastebin.com/m74527569
In my VS 2008 solution, the ASP.NET app is a seperate project from the
Workflow project.
The IIS server machine has allow delegation enabled on the domain controller.
In my ASP.NET app I have this line:
SqlWorkflowPers istenceService persistenceServ ice = new
SqlWorkflowPers istenceService( "Server=DBSERVE R;Database=WWFP ersistence;Trus ted_Connection= yes;");
And when I run the ASP.NET app I get this error:
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: Login failed for user
'NT AUTHORITY\ANONY MOUS LOGON'.
The entire error is here http://pastebin.com/m70c890db
Does anyone know what might be the cause of this headache?
Casey