Problem in connecting Sql Server to ASP.NET

I installed SQL Server in My P.C using MSDE.
it is acted as local server.
All are working fine (SQL Server and .NET)

when i am trying connect the Sql Server in .net,
i got the Error Message

"Login failed for SA/"

i am trying to Windows authentication mode,
it also gives the error like,

" login failed for Sqlserver name/asp.net"

can any one give the solution for that?

thanks in advance.

regards,
Murugavelyou need to add a user machinename/ASPNET in the users tab under your database sql server enterprise manager.

hth|||am using microsoft biztalk server but i cant see the user tab under my administration? i cant see also the server enterprise manager on my mssql. please help.|||Hi ndinakar ,

i have already created User Account in Enterpriase Manager,It is working fine in SQL SERVER
but still i got the same error message "Login failed" when connecting from ASP.NET

What is the problem?

regds,
Murugavel