IIS 6 Application Pooling rather than Impersonation

Discussion in 'ASP .Net' started by Mark, Feb 12, 2004.

  1. Mark

    Mark Guest

    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
    Mark, Feb 12, 2004
    #1
    1. Advertising

  2. 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
    =?Utf-8?B?RGlyaw==?=, Feb 13, 2004
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Punya Narra
    Replies:
    5
    Views:
    1,671
    Itai Raz
    Feb 17, 2004
  2. Nehal Shah
    Replies:
    6
    Views:
    730
    Jacob Yang [MSFT]
    Nov 14, 2003
  3. =?Utf-8?B?R3JlZyBTbWFsdGVy?=

    Migrated web site still runs in IIS rather than ASP Development Se

    =?Utf-8?B?R3JlZyBTbWFsdGVy?=, Nov 14, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    566
    Juan T. Llibre
    Nov 14, 2005
  4. Nathan Sokalski
    Replies:
    2
    Views:
    425
    joteke
    Jul 13, 2008
  5. majek
    Replies:
    0
    Views:
    935
    majek
    May 25, 2009
Loading...

Share This Page