You'll have to grant access permissions to the account used to run aspnet_wp.exe (ASPNET by default), not the account used by IIS (IUSR_ServerName), as that is the process that initiates the connection.
Csaba > -----Original Message----- > From: Philo [mailto:[EMAIL PROTECTED]] > Posted At: Wednesday, May 22, 2002 4:22 PM > Posted To: dotnet > Conversation: ASP.Net trusted connection to SQL Server 2k > Subject: ASP.Net trusted connection to SQL Server 2k > > I keep getting "Login failed for user '(null)'. I've tried everything in > the KB article: > http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307002 > but no luck. The win2k login does have access permissions in SQL Server, > but I suspect it's not getting that far. > > Win2k Server with Active Directory, IIS and SQLServer on the same machine. > > Here's the connection string: > Provider=sqloledb;initial catalog=vipar;Trusted_Connection=yes; > data source=(local);Connect Timeout=30 > > Anyone have any tips on where to troubleshoot? > > Philo > You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
