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?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
Your problem isn't anything to do with IIS, but rather it sounds like a SQL Server login permissions issue.
Check your configurations for:
You need to find out what type of authentication your ASP.NET application is using. It can be SQL Server authentication or Windows Authentication.
If it's SQL Server Authentication:
The login/password combination will be stored in the web.config file in your ASP.NET application directory. You can create a user/password in SQL Server and update the connection string to use these.
If it's Windows Authentication: The username that will be used can be either the current user (if impersonation is enabled), or the user that runs the IIS process (depending on your OS, IIS version and configuration, it can be various things). You will need to grant access for that user (or a security group that the user belongs to) to your database.