> It's not clear what's running on what box but you can add
> the login if you need to:
> exec sp_grantlogin 'NT Authority\System'
> go
> use YourDB
> go
> exec sp_grantdbaccess 'NT Authority\System'
> and whatever access it needs in whichever databases.
>
> That's not necessarily the best way to go about it though.
> It sound like your windows service is going to access
> network resources so you would want to run under a domain
> account - use User for the Account property. Then the domain
> account that the service runs under is the account you want
> to give the appropriate login and database access.
>
> -Sue
>
> On Fri, 21 Oct 2005 09:56:31 +0100, "Jan Timmer"
> <oriolus@xs4all.nl> wrote:
>
> >Enric,
> >
> >> NT AUTHORITY\SYSTEM doesn't exists in sql server
> >
> >I know but nevertheless the SQL profiler shows a user SYSTEM with loging
> >name NT AUTHORITY\SYSTEM, for the Windows Service.
> >
> >> The user that have the responsability from the asp page for do update
have
> >> the fine permissions on the selected table?
> >
> >Yes.
> >
> >
> >Jan
> >
> >
> >Enric <Enric@discussions.microsoft.com> schreef in berichtnieuws
> >71774958-F12C-46CA-B13F-39A940CD8015@microsoft.com...
> >> NT AUTHORITY\SYSTEM doesn't exists in sql server
> >> The user that have the responsability from the asp page for do update
have
> >> the fine permissions on the selected table?
> >>
> >> "Jan Timmer" wrote:
> >>
> >> > Hello,
> >> >
> >> > We have two applications that connect to three SQL databases on
another
> >> > machine. Both applications access and update the databases.
> >> > One application is a web application (ASP.NET) the other one is a
> >Windows
> >> > service.
> >> > The web application runs fine. It accesses and updates all three
> >databases
> >> > The Windows service is supposed to access and update two of the three
> >> > databases. The tables in one database are accessed and updated
> >correctly. In
> >> > the other database the only table there is can be selected, but when
ik
> >> > comes to update, a .NET exception is generated (SQL server does not
> >exist or
> >> > access denied).
> >> > When I take a look at the SQL profiler I see that the Windows Service
is
> >> > logged in as "System" with a login name "NT AUTHORITY\SYSTEM". When I
> >take a
> >> > look at the users in the database, there is no such user.
> >> >
> >> > What is the best way for me to go about to solve this problem?
> >> >
> >> > Thanks in advance.
> >> >
> >> > Jan
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >
> >
> >
>