Re: SQL Integrated Security in .NET1.1

From: basin (basingley_at_yahoo.com)
Date: 06/26/03 

Date: Thu, 26 Jun 2003 11:28:49 -0700

I changed it to just say: <identity impersonate="true"/>
I added the aspnet account to "Act as part of the
Operating System"
Now I get the message: Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.

Any more ideas?? Thanks for the help

>-----Original Message-----
>ASPNET account needs "Act as part of operation system"
right if you are
>using fixed identity.
>
>--
>Regards
>
>Matjaz Ladava, MCSE (NT4 & 2000)
>matjaz@ladava.com
>http://ladava.com
>
>"basin" <basingley@yahoo.com> wrote in message
>news:086b01c33bfb$fee0c7c0$a001280a@phx.gbl...
>> I have a developer trying to run her app on my server
>> using sql integrated security. I am getting this error
on
>> the home page:
>> Parser Error Message: Could not create Windows user
token
>> from the credentials specified in the config file. Error
>> from the operating system 'A required privilege is not
>> held by the client.
>>
>> Here is my setup:
>> In IIS, Anonymous and Windows Auth. is checked. The
>> identity of the iisusr is changed to a domain account
that
>> is added to the SQL server.
>> This line is in her web.config:
>> <identity impersonate="true" userName="domain\username"
>> password=password"/>
>> Machine.config ProcessModel is changed to use "System"
>> ASPNET account has "Act as OS" privileges.
>> Here is the conn string she has in her global/asax:
>> Application("Dem_ConnectionString")
>>
= "SERVER=ssqlServer;Database=myDatabase;Trusted_Connection
>> =True;Integrated Security=SSPI;persist security
>> info=True;Connect Timeout=120;"
>>
>> I got ALL of this from KB articles, but it STILL does
not
>> work...am I missing something??
>> Thanks!!!
>>
>
>
>.
>

Relevant Pages

  • ASPNET account and NT Authentication with SQL Server -Account Locked Out
    ... Windows NT authentication. ... seems that windows is passing the ASPNET account to the SQL server box. ... So what I did was change the password of the ASPNET account. ... and store the password in the connection string. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows Domain Groups in Authorization section sans AD
    ... ASPNET account on my SQL server. ... Web apps connect to SQL with the SQL box's own local ASPNET ... I just tried deleting the domain ASPNET account I had created, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: integrated security and using NT credentials vs. ASP.NET
    ... What you need to do is to assign permissions for the ASPNET account from the ... > My connection string is set to use integrated security. ... > SQL Server connection" ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Can my ASP.NET dev workstation see remote SQL server?
    ... If you want to use step #1 (ASPNET account) make sure you dont have ... > This domain user has been granted login on the remote SQL server, ... >> account that may be allowed access to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can my ASP.NET dev workstation see remote SQL server?
    ... If you want to use step #1 (ASPNET account) make sure you dont have ... > This domain user has been granted login on the remote SQL server, ... >> account that may be allowed access to the SQL Server ...
    (microsoft.public.sqlserver.security)