Iis – login failed for user in ASP.NET application to SQL Server 2000

iispermissionswindows-xp

Consider an ASP.NET application to an IIS instance (Windows XP Service Pack 3). The application is calling into SQL Server 2000.

When navigating to the website, an error is thrown:

LOGIN FAILED FOR USER (username)

How can you solve this problem?

Best Answer

Your problem isn't anything to do with IIS, but rather it sounds like a SQL Server login permissions issue.

Check your configurations for:

  • IIS6 pool identity
  • application's web.config ConnectionStrings node.
  • hardcoded values in your ASP.NET application at the time it's making an ADO.NET connection to your SQL Server instance.
  • ensure that login is enabled on your SQL instance. Ensure that you can login yourself via Query Analyzer.

alt text

Related Topic