IIS 6 Application Pooling rather than Impersonation

M

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
 
G

Guest

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=delegations

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top