SQL web application fails at login. Need help.

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


Date: Tue, 2 Mar 2004 15:15:31 -0800

Hey guys, I desperately need help.

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

  • 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.programming)
  • 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.setup)
  • 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)
  • SQL web application fails at login. Need help.
    ... We have an SQL database that can be accessed successfully ... from console and windows applications. ... Login failed for user 'Q-OZP..etc ... and windows applications can run the SQL tables. ...
    (microsoft.public.sqlserver.server)
  • Windows Impersonation authentication to SQL Server?
    ... Impersonation will each Windows Domain user accounts need to be granted ... all be tracked and displayed in SQL Profiler? ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.sqlserver.security)