Tip for today: A couple of years ago, one of our customers was trying get Basic Authentication in PHP working on IIS. He discovered that in order to get it to work, you can only have Anonymous Authentication enabled. All other forms of IIS authentication must be disabled.
SQL Server AutoClose and Errors
Rummaging through my notes again, I found that if you run into these errors:
- “Fatal Error 9001”
- “Database is in transition”
- The log for database ‘database_name’ is not available.
You might want to check to see if the Auto-Close property on the database was set to “true”. Setting it to “false” can correct the problem.
ReportViewerWebControl and HTTP 404 Not Found
I was digging through some old notes today and found this tip that might be helpful to someone in the future. If you’re getting a HTTP 404 Not Found or HTTP Handler related error with the ASP.NET Report Viewer Control, you can try to changing the Application Pool Pipeline Mode from Integrated to Classic to fix the problem.