login failed for the user (using MSDE)

im using MSDE , not SQL server

i have already created a new accnt named "demoasp" and
assoigned it to processmodel section of machine.config so
as to correct other error which said "server application
unavailable"

when i run my asp app .it gives following error

Server Error in '/datagrid' Application.
------------------
-------

Login failed for user 'SHAHZADPC\demoasp'.
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 'SHAHZADPC\demoasp'.Are you using a trusted connection?
You may need to add the user 'SHAHZADPC\demoasp' to SQL Server.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"shahzad" <khuwajashahzad@.hotmail.com> wrote in message
news:009301c3c45c$2332e840$a001280a@.phx.gbl...
> im using MSDE , not SQL server
> i have already created a new accnt named "demoasp" and
> assoigned it to processmodel section of machine.config so
> as to correct other error which said "server application
> unavailable"
>
> when i run my asp app .it gives following error
>
> Server Error in '/datagrid' Application.
> ------------------
> -------
> Login failed for user 'SHAHZADPC\demoasp'.
> 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 'SHAHZADPC\demoasp'.
as i have told u ,im not using SQL serve r
im using MSDE which has no UI of adding users to it
and also im using trusted connection
plz tell me wid respect to MSDE
IM NOT USING SQLSERVER...
Even though there's no UI, I'm sure it's still possible to add users. Have
you looked at this article -
http://support.microsoft.com/defaul...Ben-us%3B325022 ?

Mun

"shahzad" <anonymous@.discussions.microsoft.com> wrote in message
news:01c201c3c47a$83e91290$a001280a@.phx.gbl...
> as i have told u ,im not using SQL serve r
> im using MSDE which has no UI of adding users to it
> and also im using trusted connection
> plz tell me wid respect to MSDE
> IM NOT USING SQLSERVER...
yeah man ..
osql utility did the work
new for me tha msde can be configured..never read taht in
any book
jazakALLAH for all help

>--Original Message--
>Even though there's no UI, I'm sure it's still possible
to add users. Have
>you looked at this article -
>http://support.microsoft.com/defaul...cid=kb%3Ben-us%
3B325022 ?
>Mun
>
>"shahzad" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01c201c3c47a$83e91290$a001280a@.phx.gbl...
>> as i have told u ,im not using SQL serve r
>> im using MSDE which has no UI of adding users to it
>> and also im using trusted connection
>> plz tell me wid respect to MSDE
>> IM NOT USING SQLSERVER...
>
>.