PMFJI- Are you sure there is a user in the db that corresponds to the login? Perhaps its there but the binary value in the sysusers table doesn't match the NT security token. In other words, has the db been restored from a backup from another server/domain?
-----Original Message----- From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of Marsh, Drew Sent: Wednesday, May 22, 2002 2:22 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] ASP.Net trusted connection to SQL Server help? 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. HTH, Drew You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
