Re: SQL web application fails at login. Need help.

From: Steve Kass (skass_at_drew.edu)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 18:45:31 -0500

Mikos,

  In addition to what Erland said, can you provide the code that tries
to open a connection to the database, along with the connection string,
if it's not in the code (password removed, of course, if you are using
SQL authentication). When you say console and windows applications and
Studio can connect, do you know they are connecting as the database user
ASPNET ?

SK

Miklos wrote:

>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

  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: User not associated with trusted SQL Server connection
    ... > using the osql utility. ... > associated with a trusted SQL Server connection. ... > database or is it just for that instance. ...
    (microsoft.public.sqlserver.security)
  • RE: Manipulating MS Access records with excel VBA + ADO
    ... While I cannot see how a working example of a connection to a database is ... Select the control button view dataor edit query. ... Look for SQL button to get the SQL ...
    (microsoft.public.excel.programming)
  • Re: Is it just me or are there BIG problems with SQLCE 3.0?
    ... has been done with parameterised SQL, ... bit of code into my test which closes and reopens the database ... opening and closing the DB connection is not a good idea. ... // Display all error messages ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... What version of SQL CE are you using? ... Are you accessing the database from an app written in C++? ... then opens his work forms and it's in those ... It wouldn't seem to me that you'd need a new connection to ...
    (microsoft.public.sqlserver.ce)
Loading