connection to MSDE from WebMatrix

Hi,

I've just started to learn ASP.net using Scott Mitchell's book:ASP.NET in 24 hours. But i've got a little problem in the database section.
I couldn't connect with a MSDE from webmatrix using sql server authentication even the username and password are correct.
The error message :
"unable to connect to the database server:Login failed for user 'sa'. Reason:not associated with a trusted SQL server connection".
What does it mean? Have any of you ever had this kind of problem?
Thank you for helping me.

Regards,
tomhi!

the sa user is SysAdmin ;) the password and login authentification depends on how you set up your MSDE. what parameters have you used at the msde setup?

i'm not sure why some sql-requests require a trusted connection but it seems that if you use windows authentification you can connect to the db-server..
so the windows login seems to be a "trusted connection" but maybe you have to use the SSPI for the sql-login, just an idea how you could try to solve this ;)

hth, greetz

i might be wrong as i started learning about asp.net and sql some days ago too ^^ if that's the case plz correct me|||By default MSDE is installed with Windows Authentication only. You will have to change to mixed mode. That is my first guess on this one (may come back and edit this later with more info).

Connection Properties on Expressions?

Hi,

I can seem to find all the necessary properties of a connection in the expression section... except for the password...

How the hell do i specify the password for a connection based on a variable?

Regards,

Have you tried building a connection string and including the password that way.

Alternatively use windows authentication, but I'm sure you've thought of that.

|||

Yes i have already tought about both of them.. but in the connection String that is built using the interface and choosing SQL Auth the password is never there.. well i will try that way but it was a little bit easier and safer if the connection could receive a Password parameter and possibly encrypt it for use... don't know!

I'll try and see about that!

Regards,