ASP.Net Permissions

Hi
Try as I might I really can't work out to do this (I've searched
usenet and help).
My ASP.NET application needs to access an SQL Server 2000 database (on
a Windows 2003 box). I appear to be running mixed mode authentication.
I want to connect to the box using intigrated security. I think all I
need to do is apply appropriate permissions to 'NT AUTHORITY\NETWORK
SERVICE'.
I can't work out where and how to do this! What permissions and which
app I use to make the changes etc?
Can anybody help?
Sorry for the lame question.
Cheers
AlexIf you want to use integrated security, then you need to enable the
ASPNET windows account and grant it permissions in the database since
that is the worker process account that asp.net uses. However, it may
not be that simple if SQLS and your web server are running on
different boxes. There is an excellent asp.net security best practices
whitepaper you should read before proceeding further:
http://www.microsoft.com/downloads/...ReleaseID=44047
--Mary
On 30 Jul 2004 04:13:22 -0700, postings@.alexshirley.com (Alex Shirley)
wrote:

>Hi
>Try as I might I really can't work out to do this (I've searched
>usenet and help).
>My ASP.NET application needs to access an SQL Server 2000 database (on
>a Windows 2003 box). I appear to be running mixed mode authentication.
>I want to connect to the box using intigrated security. I think all I
>need to do is apply appropriate permissions to 'NT AUTHORITY\NETWORK
>SERVICE'.
>I can't work out where and how to do this! What permissions and which
>app I use to make the changes etc?
>Can anybody help?
>Sorry for the lame question.
>Cheers
>Alex|||Thanks. They are both running on the same box. I'll look into the article.
I simply want to assign permissions to that service and I don't know how.
Thanks
Alex
Mary Chipman <mchip@.online.microsoft.com> wrote in message news:<oholg09nuoo7j58rbufdo5fcldu
efc3ch4@.4ax.com>...[vbcol=seagreen]
> If you want to use integrated security, then you need to enable the
> ASPNET windows account and grant it permissions in the database since
> that is the worker process account that asp.net uses. However, it may
> not be that simple if SQLS and your web server are running on
> different boxes. There is an excellent asp.net security best practices
> whitepaper you should read before proceeding further:
> http://www.microsoft.com/downloads/...ReleaseID=44047
> --Mary
> On 30 Jul 2004 04:13:22 -0700, postings@.alexshirley.com (Alex Shirley)
> wrote:
>