SQL web application fails at login. Need help.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Miklos (zsoltesz_at_adelphia.net)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 15:13:36 -0800

We have an SQL database that can be accessed successfully
from console and windows applications. However,
essentially the same code fails at login when trying to
access web applications.

The error message is:
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 'Q-OZP..etc(our computer name)
\ASPNET'.

We have a computer with dual boot Windows XP Pro and
Windows XP Home. We installed Microsoft Visual Basic.NET
2003 and Microsoft Desktop Engine (MSDE). Both console
and windows applications can run the SQL tables. Studio
can view the SQL tables. In the component tray, it shows
SQL service running. In Windows Management, MSSQL server
cannot be seen, but if you click on "services" from in
there, it shows the SQL service running.

We attached the database with OSQL but aren't sure if we
did it properly, and set up MSDE but aren't sure if we did
that properly.

Do any of you know how to fix this?

Thank you very much,

Miklos

Relevant Pages

  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: Keeping User From Deleting Table Records
    ... authentication and authenticate with Windows. ... Is this Windows "read" permission ... Windows or is this SQL-assigned read permission done through SQL ... SQL login, and grant only read permissions to that user. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL web application fails at login. Need help.
    ... >to open a connection to the database, ... >SQL authentication). ... >>from console and windows applications. ... >>and windows applications can run the SQL tables. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Authentication with multiple roles is only for small apps?
    ... The above statement is true but isn't limited only to Windows logins: ... authentication) and using an application Windows account for SQL Server ... on the middle tier if it uses the same login for all connections. ...
    (microsoft.public.sqlserver.security)
  • SQL web application fails at login. Need help.
    ... We have an SQL database that can be accessed successfully ... from console and windows applications. ... essentially the same code fails at login when trying to ... and windows applications can run the SQL tables. ...
    (microsoft.public.sqlserver.msde)