Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

From: ecoder (lvd_at_vip.cybercity.dk)
Date: 07/08/03


Date: Tue, 8 Jul 2003 17:18:35 +0200


Hey Nick....

Will you please specify, exactly how you do what you describ?

Creating what role where and how!

I would be very pleased if you would do that, because I have similar
problems..... :-(

Greetings

Luciano Gio Gambinni

"Nick Gilbert" <news@nickgilbert.com> wrote in message
news:%23fcKRZYMDHA.3088@TK2MSFTNGP10.phx.gbl...
> Create a new role in the database called something like WWWUser, then set
up
> the permissions on that role. Finally add the NT AUTHORITY\NETWORK SERVICE
> to that role. Don't ever set the permissions against a particular user
> directly as it can cause problems when transferring databases between
> servers or make your life difficult if you change your security model.
For
> example, if you found you needed to host on Windows 2000, there is no
> NETWORK SERVICE user, so you need to use the MACHINENAME\ASPNET user
> instead. It would be quite simple to just swap the users over within that
> role rather than having to reset the permissions on every single table and
> stored procedure just because the user had changed.
>
> Nick...
>
> "buran" <buran@buran.com> wrote in message
> news:O9s6vOXMDHA.3664@tk2msftngp13.phx.gbl...
> > Dear ASP.NET Users,
> >
> > I installed Windows 2003 Standard Edition, then Visual Studio .NET and
SQL
> > Server 2000 with SP3. When I build web project connecting to the
database
> in
> > VS.NET, the compliler gives me the following error:
> >
> > Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
> >
> > Has anyone experienced similar problem or how can I solve it?
> >
> > Thanks,
> >
> > Burak Kadirbeyoglu
> >
> >
>
>