Re: SQL server does not exist or access denied

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@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in berichtnieuws
71774958-F12C-46CA-B13F-39A940CD8015@xxxxxxxxxxxxxxxx
> 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
> >
> >
> >
> >
> >
> >
> >
> >
> >




.

Relevant Pages

  • Re: moving Windows Embedded Data folder location
    ... Yes you can relocate the location of the DB if you are have Windows admin priveleges on the machine and also are a SQL admin on that machine. ... Back in the SQL Management tool, go to the 'Databases' node, right click and choose 'attach'. ...
    (microsoft.public.windowsxp.embedded)
  • Re: SQL 7 on Windows 2003 Server
    ... SQL 7 is not supported under Windows 2003. ... There are 2 alternatives to upgrade. ... Detach the databases or backup the databases ...
    (microsoft.public.sqlserver.server)
  • Re: SQL server does not exist or access denied
    ... and whatever access it needs in whichever databases. ... It sound like your windows service is going to access ... account - use User for the Account property. ... >I know but nevertheless the SQL profiler shows a user SYSTEM with loging ...
    (microsoft.public.sqlserver.connect)
  • Re: CBH file-format spec and the need for a new database program?
    ... Sure, most users will be under Windows, but it ... over MFC or generic Windows libraries myself - it's just newer. ... Chess databases don't use SQL - not any I've seen - and they aren't really ...
    (rec.games.chess.computer)
  • Trigger problem due to OS...
    ... standard codes on all the databases on all the servers. ... have 20 databases on 5 MS SQL Server 2000 and the OS for ... Stored proc updates on all 20 databases across all 5 SQL ... SQL server 2000 running on Windows 2003. ...
    (microsoft.public.sqlserver.programming)
Loading