How can I authenticate a User with Sql Server 2000 Sql Authentication, do I
need to use sqldatasource control or something else ?

Say, my User Name is : sa, and Password is: mypwd, initial catalog=Northwind

I tried following :

Login1_Authenticate(...)

sqldatasource.connectionstring="Data Source=MyServer; User ID=sa;
Password=mypwd; Initial Catalog=Northwind"

Whats next, I don't know

If login is succeeded, then response.redirect("Main.aspx")

End sub

Any idea please ?

Best Regards.

Luqman