Re: SQL Integrated Security in .NET

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


Date: Thu, 26 Jun 2003 08:59:01 -0700


Thanks a lot!

>-----Original Message-----
>Act as part of the operating system privilege (highly not
recommended) is
>the usual cause for this message, but you already have
that. Forwarding to
>the Aspnet.Security group which normally discusses these
issues.
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm
>
>
>"basin" <basingley@yahoo.com> wrote in message
>news:06de01c33bec$fa84e580$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

  • Re: SQL 2000 installation advice needed
    ... this option when installing SQL Server? ... > If you mean with that the local administrator account, ... > Security is not very important to me. ... >> Ghost backups of the operating system, and will backup the database daily. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot upgrade a licensed sql2000 to a MSDN 2005
    ... SQL Server Edition Operating System Compatibility (Warning) ... Installing SQL Server 2005' in Microsoft SQL Server Books Online. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • SQL Query Analyzer Connectivity to a remote SQL Server
    ... I connect to a remote SQL Server with DBAdmin rights, ... that server from any operating system, when i connect query analyzer through ... Windows2000 Professioanl Operating system (IN WHICH SQL Server2000 also ...
    (microsoft.public.sqlserver.connect)
  • Re: Trying to figure this one out
    ... The operating system is WIndows 2000 ... It is also running SQL Server 2000 Standard ... I've never used either of those drivers, but I've had good experiences with the free jTDS driver. ...
    (comp.lang.java.databases)
  • Re: Cannot upgrade a licensed sql2000 to a MSDN 2005
    ... and eventually MSDN 2005 developer or standard edition. ... However I was not able to get sql server 2005 sp2 to get installed, ... I still could not install sql server 2005 (MSDN standard edition using the ... Article: Operating System Minimum Level Requirement, ...
    (microsoft.public.sqlserver.setup)