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.

[techgnome]

By default sa has no password. Unless, you've changed it, try that.

Some thing else to look at: Make sure the user has permissions to use the database.


TG

[udit99]

I dont know about the previous MSDE version but the one that I installed won't let me install it without a strong password....so I do have a password for sa...and as far as the security thing goes...at first it was hard for me to figure out without any client tools as to how I could check for security...but then I installed MS SQL Web Data Administrator and it gave me this....I assume this means that I have all the rights to the db.

EDIT USER DBO


Login name: centralcollege\manektalau1
Roles: public checked
db_owner checked
db_accessadmin checked
db_securityadmin checked
db_ddladmin checked
db_backupoperator checked
db_datareader checked
db_datawriter checked
db_denydatareader checked
db_denydatawriter checked

so I still can't figure out why its giving me a Login Failed !!

[udit99]

I tried the sa login now and it works!!...the Windows Authent. doesnt...but that doesnt matter

thanks...