IIS 6 Application Pooling rather than Impersonation

[Mark]

A consultant mentioned that IIS 6 Application Pooling could be used in place
of Impersonation when authenticating on a windows network between two
different servers on the same domain - one with IIS and the other with SQL
Server. However, it appears that like Impersonation, we're going to have to
use a domain account and manage a domain password to pull this off. How
exactly would it work with Application Pooling authenticating to SQL Server?

Thanks in advance!

Mark

[Dirk]

You do not have to set up a domain account you can just run the application pool as the server network service account. Then make the network service account of the web server a login in SQL (Network service account is called ServerName$ on the network) and assign it to the appropriate database

Now your connection string can be

"server=ws019533;Trusted_Connection=Yes;database=d elegations

Hope this helps