"Login Failed" Error Message When You Create a Trusted Data Connec

From: Les K. (LesK_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 14:25:04 -0800

I need to Split my Database and Web Server. Logins work fine when database is
Local.
This is my setup:
I have a Group setup on the Domain controller called PL_A.
in this group I have all the users that can access this resource.
I have two servers running windows2003, one is running sql2000, the domain
group is authenticated as a user to one of the databases we are connecting
too.
The Other server is running IIS6, asp.net , only windows authentication is
selected on the IIS, in “web config”
server=viper;database=Viper_Common;Trusted_Connection=yes; connection
timeout=240;<authentication mode="Windows" />
<identity impersonate="true" />
Both servers are on the corporate network, I have a private connection from
the database server and the web server using a crossover cable.
I get an error when I debug, null user not authenticated.
How do I pass the user logging into IIS to the sql2000 database?

Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... JavaScript, for example) and thus, will get the time from the web server, ... function on the client. ... the database is not the place to put a time stamp of this ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Re: Can we use DAPs to access remote MDB files?
    ... the server and the user will not know it's happening. ... web server (from the client) and others seem to be saying it's NOT ... multi-user database pretty well straight out of the box. ...
    (comp.databases.ms-access)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)