SQL Connection

[Guest]

I use "WIndow Authentification" to sign on to "Microsoft SQL Server
Management Studio Express". I create and account with "SQL Server
Authentification" and assigned a password. I also identify the database that
this ID has access to. When I then try to login with this id, I get a "Login
Failed for user 'Fred'. The user is not associated with a trusted SQL Server
Connection....Error: 18452". Why am I getting this error?

I assummed that if I am going to be using ASP.Net to sign on an read/update
a database table, that I need to create an ID and password for that activity.
Would that not be an accurate assesment of what needs to be done?

Thanks in advance for your assistance!!!

 

[Guest]

You need to enable Mixed Mode Authentication in SQL Server.

 

[hamedvahedi]

you should login with user named "sqlexpress\Fred"