且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

经典ASP问题连接到远程SQL Server数据库

更新时间:2022-11-30 09:04:29

对于要使用应用程序池标识用于经典ASP的网站,您需要更改所使用的凭据匿名验证。默认情况下,网站将设置为使用特定用户,即IUSR。

For a site to use the application pool identity for classic ASP, you need to change the credentials used for Anonymous Authentication. By default, the site will be set to use a specific user, namely IUSR.

从您网站的IIS区域选择验证选择匿名验证,然后选择编辑。从特定用户更改为应用程序池标识

Select Authentication from the IIS area of your site, then select Anonymous Authentication followed by Edit. Change from Specific user to Application pool identity.

建议使用Windows身份验证(集成安全性)通过SQL身份验证,以便您的配置文件中没有凭据因此,如果这些文件被泄露,您不会失去对凭据的控制。

It's advisable to use Windows authentication (integrated security) over SQL authentication so that you don't have credentials in your config files so that if those files are compromised, you don't lose control of the credentials.