RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.

Steven,

Ok, it's still broken, so to reply to your original questions...

Hi Dan,

The error message did indicate that the login user doesn't have sufficient
permission access the target database, and since you mentioned the error
occur at the connection opening time, it is likely the calling
application's security identity doesn't have sufficient permission.
Currently I'd like to confirm the following information:

1. Are you running the ASP.NET application on a windows 2003 server with
IIS 6(also the ASP.NET application is hosted in IIS rather than .net test
server)?

IIS 6 running on Win2k3 Standard. The app is running in it's own AppPool and
its built on .NET v2.0.50727.

2. Are you connecting to a SQL Server database in server engine or a SQL
Express data file?

MSDE, so thats SQL Server Engine I think? :)

3. If convenient, would you also paste the connectionstring to us(whether
use sql authentication or integrated windows)..

Don't have it to hand, but I could get it if necessary... I can tell you
that we use Windows Authentication for the app, and I think the sql conex
string is using a Trusted Connection.

Okay, you then said...

If you're using IIS6, then the ASP.NET security context should be the
application pool's identity (if you're not using impersonate in ASP.NET),
and by default the application pool identity is "NT AUTHORITY\NETWORK
SERVICE", however ,it is possible that someone changed it to other ones
such as LOCAL SYSTEM or LOCAL Service(these three accounts is common ones
used by service application).

This is a possibility cos I'm not the server Admin, so something could have
been changed by someone else. How do I check/change the Security context?

Thanks for your time!



"Steven Cheng[MSFT]" wrote:

Thanks for your followup Dan,

Nevermind. Just keep your focus on your first priority items and if there
is anything else need help later, please feel free to post here.

Regards,

Steven Cheng

Microsoft MSDN Online Support Lead


==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================


This posting is provided "AS IS" with no warranties, and confers no rights.



Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


.

Relevant Pages

  • Re: Event 1000 Windows SharePoint Services 2.0 Error
    ... First off what exact error message do you get? ... I've not seen Exchange pop connector get mangled by removing SQL so lets debug that separately. ... I had all SQL server instances to a complete stop. ... And this morning when I came to work, I discovered that when I try to access http://companyweb/, I receive the "Cannot connect to the configuration database." ...
    (microsoft.public.windows.server.sbs)
  • Re: OT: MS SQL access
    ... conflicting port numbers used by MS SQL databases. ... The error message was 19011 which tell you that the system was unable to ... Does this only happen when you reboot, ... make sure the server is fully up and running ...
    (comp.sys.hp.mpe)
  • Re: timeout expired on View
    ... Error Message: Timeout expired. ... SQL Server Driver]Timeout ...
    (microsoft.public.sqlserver.tools)
  • Re: Sql server down when Edit Data
    ... > Server error log and event log for errors? ... > Vyas, MVP (SQL Server) ... error message appears. ...
    (microsoft.public.sqlserver.connect)
  • Re: Help---Run-Time error
    ... cable and network card for new server. ... So I think it is still a SQL sever issue. ... This message generally means that your network is having a problem, ... > of client users have been getting the error message sereral times> casually ...
    (microsoft.public.sqlserver.odbc)