In the test environment (2 IIS web servers, 1 SQL server, 1 IIS Utility server) none of our DB-driven apps are working. We cannot figure out the issue, but we think that MDAC is hosed.

General question:We recently switched one of our applications to Application Role security, which mandates (because the backend is SQL2000) that we turn off .NET Connection pooling for the sql ...

However, it might be useful to know that you can not only run PHP on Windows servers using Internet Information Services, but also connect to SQL Server for data.

Although there has been a new IIS vulnerability disclosed in recent weeks, the attacks are only making use of poor site and database maintenance practices - using SQL injection to exploit sites.

A free download, the Web Application Configuration Analyzer scans IIS servers, hosted applications, and SQL Server instances for common security issues and misconfigurations.