Re: SQL web application fails at login. Need help.
From: Miklos (zsoltesz_at_adelphia.net)
Date: 03/03/04
- Next message: Lasse Edsvik: "Error running sp_vupgrade_replication(1)"
- Previous message: Miklos: "Re: SQL web application fails at login. Need help."
- In reply to: Steve Kass: "Re: SQL web application fails at login. Need help."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Mar 2004 01:25:30 -0800
Dear Steve,
Thanks!
I fixed it. Not sure why.
Most likely putting ASPNET
into administrator group.
Miklos
>-----Original Message-----
>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
>>
>>
>>
>
>.
>
- Next message: Lasse Edsvik: "Error running sp_vupgrade_replication(1)"
- Previous message: Miklos: "Re: SQL web application fails at login. Need help."
- In reply to: Steve Kass: "Re: SQL web application fails at login. Need help."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
