Topic: Error - Login failed for user
Error "Login failed for User '(null)'
1. Open up IIS
2. Go to the Virtual Directory for your application
3. Right click and open up properties
4. Go to the "Directory Security" tab
5. Click on "Edit" in Anonymous access and authentiaction control panel
6. Click on "Edit" in the Anonymous access panel
7. Browse for the user that is a user in the database
8. Add the password if needed
9. I don't think you need to check the "Allow IIS to control password" checkbox
10. Not sure if you need to uncheck the "Anonymous Access" checkbox for the panel
Note:
You may have to change the connection string in ASP.NET to use the same
credentials that your database is using (e.g. DavesASPNet and password)
Note:
You may have to make sure that the user role you are using is allowed
to perform SELECT's, UPDATE's, etc... on the tables your are trying to hit.
1. Rightclick on the tables and look at the permissions.
2. Add the role/user if necessary and grant permissions where needed.