Error message: Login failed for user 'sa'.

[chelvis]

In my login form, when I type my username and password to create a new account, if is giving the following error message:

Login failed for user 'sa'.

Originally/Earlier I got the same error but like this:
Login failed for user ‘sa’. Reason: Not associated with a trusted SQL Server connection

So I went to SQL Server 2000 enterprise manager and did the following:
Right click the server name and click properties
click on Security tab
Under authentication, click the SQL Server and Windows option button and then restarted SQL Server.

But still I am getting the error message: Login failed for user 'sa'.

What more settings I have to do?

Thanks

[roda]

which login form u mean , in the SQL Server or the login form u made it using ASP.NET?

[roda]

if u mean the login form u made it in the asp.net
This means that u have made the connection visually , in this case after creating the connection u should go to the connection string of the connection Properties and add the underlined statment (;password=_____ ) the password of the user sa in SQL server

[chelvis]

I didnt understand exactly what you meant. Yes this error is for the login page I made (login.aspx). Could you please explain it?

Thanks for your help.

[roda]

have u created sqlconnection from the data tab in the toolbox?

[chelvis]

Yes, I have done what you said earlier and now everything works fine. Thanks very much roda