SQL2k5 : Login failed for user 'KLEO\ASPNET'

From: Mr.KisS (anonymous_at_discussions.microsoft.com)
Date: 07/06/04


Date: Tue, 6 Jul 2004 02:04:31 -0700

Hello all,

I'm working with Windows XP PRO SP1, ASP.NET v2 (with
Visual Web Dev) and, MS SQL 2005 with a database with
Windows Authentication mode. I've an aspx page which must
send a query to the database. But i have this exception :

Login failed for user 'KLEO\ASPNET'.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.
Exception Details: System.Data.SqlClient.SqlException:
Login failed for user 'KLEO\ASPNET'.

I have put TOTAL CONTROL to the ASPNET User for the
"wwwroot" folder.

What must i do to resolve this problem?
I dont know how to change the rights of KLEO\ASPNET
for the SQL Server. How to do? I'm under MS SQL 2005
Express. There isn't an enterprise manager or visual guide.
Have you a command line or something that i could use?

Regards.



Relevant Pages

  • Re: Database for a WM5 device
    ... It sounds like I can use SQL CE on my WM5 device. ... .CreateDatabase line is generating an exception and I cannot figure out ... CE database on the desktop. ...
    (microsoft.public.pocketpc.developer)
  • Re: Reliably reproducing Native Exception 0xc0000005 on SQL CE 2.0
    ... SQL CE QP is not going to be able to optimize that stmt. ... >I am reliably reproducing the ExceptionCode 0xc0000005 native exception ... > SQL CE 2.0 database file ...
    (microsoft.public.sqlserver.ce)
  • Error : Login failed for user MACHINEASPNET :/
    ... Visual Web Dev) and, MS SQL 2005 with a database with ... send a query to the database. ... An unhandled exception occurred during the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Error Message for Logon
    ... Your web site is setup for anonymous logon, ... your connection to the database is set to use SQl Integrated Security. ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.dotnet.security)
  • Re: Ado.net performance question (SQL server vs OleDB data provider)
    ... All the possible exceptions are caught in the Database class ... and wrapped in my own exception type. ... I haven't had an opportunity to benchmark the Sql database provider classes ...
    (microsoft.public.dotnet.framework.adonet)