ASP + SQL 2000 + Win2k SP4

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sharon McCaughan (sharon_mccaughan_at_dell.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 08:51:52 -0700

Getting the following error when I try to connect to my website

Error starting session:
- cannot open connection to datastore.
- Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

OS is Windows 2000 and SP4 on both the IIS server and SQL server, SQL is
SQL 2000 sp3a
IIS Security for the vitual directory: Properties of TheMatrix virtual
directory
Edit 'Anonymouns access and Authentication Control'
disable annonymous access
enable Integrated windows authentication.

Connection string in_appStart.asp =
application("sADOConn") ="Provider=SQLOLEDB;" &_
         "Initial Catalog=TheMatrix;" &_
         "Data Source=sqlServerName;" &_
         "Integrated Security=SSPI;"

There is a role for domain users to use giving them execute permissions
on all stProcs, then domain\users is added to the role.
SQL server is windows authentication

>From Query Analyser on my desktop, when I connect to the SQL server and
run 'select syste_user', my own user account in the domain is correctly
returned.

My application works fine (hopefully) but authentication to SQLServer
via delegation/impersonation is not set up correctly. It may
be a SP4 issue, can anybody please help me with this. It's really
important I get this working.

Many thanks.
Sharon

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: More on that login problem - found the logs -
    ... I see that I'm using both SQL Server and Windows authentication; ... "Startup service account" startup runs the ... Should I try to make a new SQL server registration? ... Not associated with a trusted SQL Server connection"). ...
    (microsoft.public.sqlserver.connect)
  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: More on that login problem - found the logs -
    ... Verify that you are using both SQL Server and Windows authentication using ... Not associated with a trusted SQL Server connection"). ... Which account are you using to connect to the database? ...
    (microsoft.public.sqlserver.connect)
  • Re: Domain or Workgroup
    ... As far as SQL Server 2000 is concerned, Domain users are the way to go. ... Windows authentication provides better security, better password control, ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.clients)