ASP-MSDE connection problems[closed]

[udit99]

Trying to get an ASP page to connect to a MSDE DB


When I use this :
MyConnection = New SqlConnection("server=(local);database=northwind; uid=sa; password=testpassword")

I get this

Cannot open database requested in login 'northwind'. Login fails. Login failed for user 'sa'.


and When I use this ( my Windows logon)

MyConnection = New SqlConnection("server=(local);database=northwind; uid=manektalau1; password=testpassword")

I get
Login failed for user 'manektalau1'

the problem persist even if I add my domain name before my windows logon....


when I do this C:\>osql -u or this C:\>osql -e
I get

Error: No user selected. Try with -U or -E switches


I have already changed that authentication mode registry setting from 1 to 2.