ASP-MSDE connection problems[closed]
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.