Impersonate code sample?

[Chris Jackson]

Here is what I do in order to use Windows security:

1. Set up IIS to use the domain account you have set up as the anonymous
user
2. Set up ASP.NET to impersonate, so it will use this domain account. Just
add <identity impersonate="true"> to web.config
3. Set up permissions for this account on the SQL Server
4. Start using Windows Security

If you have any components that you access, don't forget to give the domain
account access to them as well.

I do this for Forms Authentication - I assume it is similar for Windows
Authentication, but can't personally comment on things to look out for.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows XP
Windows XP Associate Expert
--
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netRemuvThis> wrote in
message news:u2ThbiVTDHA.1324@TK2MSFTNGP11.phx.gbl...

> One of the guys at work is creating an ASP.NET app against a legacy COM
> component that uses SQL Server Integrated security. Somewhere recently, I
> saw a code sample that showed how to impersonate an account for data

access

> by changing the identity of the thread the ASP.NET application was running
> under. To save him some time, does anyone have a link to a sample like

this.

>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> Author: ADO.NET and XML: ASP.NET on the Edge
>
>

************************************************** **************************

> ****
> Think Outside the Box!
>

************************************************** **************************

> ****
>
>

[Naveen K Kohli]

Here is some code that you may be able to use.

[url]http://www.netomatix.com/ImpersonateUser.aspx[/url]

Naveen

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netRemuvThis> wrote in
message news:u2ThbiVTDHA.1324@TK2MSFTNGP11.phx.gbl...

> One of the guys at work is creating an ASP.NET app against a legacy COM
> component that uses SQL Server Integrated security. Somewhere recently, I
> saw a code sample that showed how to impersonate an account for data

access

> by changing the identity of the thread the ASP.NET application was running
> under. To save him some time, does anyone have a link to a sample like

this.

>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> Author: ADO.NET and XML: ASP.NET on the Edge
>
>

************************************************** **************************

> ****
> Think Outside the Box!
>

************************************************** **************************

> ****
>
>

[Brian Pieslak]

I downloaded the Sample source code and modified it to match my
username, password, and domain in my office.
I tried the permutations of LogonType and LogonProvider for w2k, and
unfortunately, I could not get the example to work

Has anyone been able to successfully implement Impersonation on Windows
2000 Server?
If so, could you share a sample of source code?

Thanks,
Brian

"Naveen K Kohli" <naveenkohli@hotmail.com> wrote in message
news:e%23wfxIaTDHA.2092@TK2MSFTNGP10.phx.gbl...

> Here is some code that you may be able to use.
>
> [url]http://www.netomatix.com/ImpersonateUser.aspx[/url]
>
> Naveen
>
> "Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netRemuvThis> wrote

in

> message news:u2ThbiVTDHA.1324@TK2MSFTNGP11.phx.gbl...

> > One of the guys at work is creating an ASP.NET app against a legacy COM
> > component that uses SQL Server Integrated security. Somewhere recently,

I

> > saw a code sample that showed how to impersonate an account for data

> access

> > by changing the identity of the thread the ASP.NET application was

running

> > under. To save him some time, does anyone have a link to a sample like

> this.

> >
> > --
> > Gregory A. Beamer
> > MVP; MCP: +I, SE, SD, DBA
> > Author: ADO.NET and XML: ASP.NET on the Edge
> >
> >

>

************************************************** **************************

> > ****
> > Think Outside the Box!
> >

>

************************************************** **************************

> > ****
> >
> >

>
>