IIS Giving Me a Headache

[Jesus4u]

I had to reinstall IIS because out of nowhere I was getting a Server Application Error on my local Win2000 Prof box when trying to connect to a SQL2000 database in the webbrowser using ASP.

Now the previous error is gone but now the SQL permissions do not allow the IUSR account to access the database. I have checked all the permissions in SQL and all appears to be ok.

Now what? I still get a login error in the browser for SQL!!!!!!!! Exams Passed: 70-152, 70-175, 70-176, 70-100

 

[Patbeau]

Maybe this is a windows account issue. Look in service to see the account you use for SQL server and look into your SQL server for the type of access. I dont know if it can be the solution but I had weird issue with SQL Server + Cold Fusion when I was trying to make a better security.