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
Luciano Gio Gambinni
"Nick Gilbert" <newsnickgilbert.com> wrote in message
news:%23fcKRZYMDHA.3088TK2MSFTNGP10.phx.gbl...up> Create a new role in the database called something like WWWUser, then setFor> 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.SQL> 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.
> "buran" <buranburan.com> wrote in message
> news:O9s6vOXMDHA.3664tk2msftngp13.phx.gbl...> > Dear ASP.NET Users,
> > I installed Windows 2003 Standard Edition, then Visual Studio .NET anddatabase> > Server 2000 with SP3. When I build web project connecting to the> 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