At 03:22 PM 5/22/2002 -0400, Marsh, Drew wrote: >Philo [mailto:[EMAIL PROTECTED]] wrote: > > > Even if it wasn't wouldn't I get > > Login failed for user 'domain/name'? > > > > "Login failed for user (null)" seems to me like IIS isn't > > sending a user name, or am I misunderstanding the process? :) > >Hmmm... no I believe you would get "(null)" because when using trusted auth >first the web server, acting as the client, will attempt to connect to the >database server. The database server will see that you're specifying trusted >auth via the connection string and ask windows to authenticate you. If >Windows can't authenticate you, then you're "(null)" because SQL couldn't >obtain the user information from Windows.
Any idea where I might be able to get an audit or trace of what's going on between IIS and SQL? I've tried logging in as admin and still get the user null error. I keep looking at this KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q176377 But I *am* running SQL and IIS on the same machine and using (local) as the connection. Philo You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
