Re: SQL web application fails at login. Need help.
From: Miklos (zsoltesz_at_adelphia.net)
Date: 03/03/04
- Next message: Miguel: "Enterprise Manager error asign memory"
- Previous message: jobi: "mmc register server wizard fails ..."
- In reply to: Jeff Dillon: "Re: SQL web application fails at login. Need help."
- Next in thread: Jeff Dillon: "Re: SQL web application fails at login. Need help."
- Reply: Jeff Dillon: "Re: SQL web application fails at login. Need help."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 3 Mar 2004 01:31:38 -0800
Dear Jeff,
Thanks!
I fixed it. Not sure why.
Most likely putting ASPNET
into administrator group.
How can I log in as Query Analyzer?
Miklos
>-----Original Message-----
>The error says that ASPNET login fails.
>
>Try logging in with Query Analyzer with this login, and
I suspect you'll see
>the problem.
>
>Jeff
>
>"Miklos" <zsoltesz@adelphia.net> wrote in message
>news:5fd501c400ac$79fd39f0$a101280a@phx.gbl...
>> 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: Miguel: "Enterprise Manager error asign memory"
- Previous message: jobi: "mmc register server wizard fails ..."
- In reply to: Jeff Dillon: "Re: SQL web application fails at login. Need help."
- Next in thread: Jeff Dillon: "Re: SQL web application fails at login. Need help."
- Reply: Jeff Dillon: "Re: SQL web application fails at login. Need help."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
