RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng[MSFT])
- Date: Tue, 04 Jul 2006 08:51:26 GMT
Thanks for your followup Dan,
I'm sorry to hear that the problem still remain. I still think the issue is
due to the security context of the application that used to access the MSDE
db. For your further questions:
MSDE, so thats SQL Server Engine I think? :)
===================================
Yes, MSDE is a desktop database engine in contrast to SQL Server 2000
server engine. Currently SQL 2005 has shipped a new free desktop engine
named "SQLExpress". (This is much more powerful and I would suggest you
have a look at your convenience:) )
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.
=========================
Since you can confirm that the connection is using trusted
connection(windows authentication), the decent string is not necessary.
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?
======================================
You can use the following code snippet to display the current security
identity of ASP.NET worker thread(be executing):
Response.Write("<BR/>Security Identity: " +
System.Security.Principal.WindowsIdentity.GetCurrent().Name);
BTW, since you're caring about the identity used to access the SQL server
(MSDE), you can put the above code right before the connection opening code.
Hope this helps. Please feel free to post here if there is anything unclear
or any other problem on this.
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.)
.
- Follow-Ups:
- RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- From: Steven Cheng[MSFT]
- RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- References:
- RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- From: Steven Cheng[MSFT]
- RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- From: musosdev
- RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- Prev by Date: RE: Problem in Bulk Uploading of XML data?
- Next by Date: Re: How to use client-side assembly via a web application
- Previous by thread: RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- Next by thread: RE: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.
- Index(es):
Relevant Pages
|
