« Previous Next »

• 10-30-2009, 11:59 AM

  marcus74 Joined on 10-30-2009, 3:45 PM Posts 1

  Windows Authentication | SQL Server | Classic ASP Reply Contact Hi,  i´ve good a problem with our IIS 6.0 and the  Windows Authentication. We change our SQL Server from SQL Authentication to Windows Authentication (its a seperate Server). If i open a testpage with database connect, i´ve got follow error message:   Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.   What kind of settings are necessary that all users in our domain can open the page.  Thanks a lot for your help!   Best regards, Marcus

• 10-30-2009, 1:33 PM

  In reply to

  jeff@zina.com Joined on 09-26-2003, 10:43 AM Naples, FL, USA Posts 2,103

  Re: Windows Authentication | SQL Server | Classic ASP Reply Contact marcus74: We change our SQL Server from SQL Authentication to Windows Authentication Change it back.  You need to use the proper authentication and accounts to match your connection string for ASP Classic.  When you changed to Windows accounts on your SQL Server, you now need to add those accounts to SQL wehich will be logging into SQL. Jeff Look for Wrox's new book Professional IIS 7 in your local bookstore, or order now at Amazon.com

• 10-30-2009, 1:54 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,232	Re: Windows Authentication | SQL Server | Classic ASP Reply Contact http://sqlserver2000.databases.aspfaq.com/why-do-i-get-login-failed-for-user.html Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/