Re: Integrated security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sahil Malik (contactmethrumyblog_at_nospam.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 14:35:27 -0500

BTW, I don't claim to be an ASP.NET expert :), but I have to add that you
might be able to get AWESOME help in the aspnet newsgroup too .. but hey not
like I don't wanna help .. :), so please do ask away. I might learn
somethin' new if nothin' else.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

"Arne" <Arne@discussions.microsoft.com> wrote in message
news:DC1BFE3B-5D0E-4D23-9377-E8AA2AE8B61C@microsoft.com...
> Sahil,
> Thanks for the information, but it leaves a lot of questions unanswered.
> If I create a new NT account that matches my sql login, what kind of NT
> privileges do I have to give to it?
> I use IIS 5.0 and IIS 5.1 most of the time.
>
> Arne.
>
>
> "Sahil Malik" wrote:
>
> > The instructions for IIS 6 and 5 are vastly different. I'll just assume
> > you're using IIS 6 (partly because I'm hella lazy), and give you the
> > instructions for only those. If you are using IIS 5, lemme know and I'll
> > give you those instructions instead.
> >
> > So in Win2k3, IIS 6, you have this ulta new hall cool thing called
> > "Application Pools". In IIS manager under control panel ->
Administrative
> > Tools -> IIS Manager, you can simply create a new application pool,
> > configure it to use a particular username password that has access to
the
> > SQL Server, and then go to the virtual directory/website, and in it's
> > properties instruct it to use that particular application pool.
> >
> > Thats it, you got integrated security on ASP.NET now .. isn't that COOL?
:)
> >
> > Obviously there are other ways to acheive this, but I like this method
the
> > mostest :)
> >
> > - Sahil Malik
> > http://codebetter.com/blogs/sahil.malik/
> >
> >
> >
> > "Arne" <Arne@discussions.microsoft.com> wrote in message
> > news:94A74A1A-E400-4B0F-A39D-4C8538BA6E2C@microsoft.com...
> > > How do I create trusted security between my web server and my sql
server?
> > > I don't know the account and password that my web server is running
under.
> >
> >
> >