How to use Login Control in VS.2005 to Authenticate User ?

[Luqman]

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

[DWS]

look for aspnet_regsql in help
Good Luck
DWS
"Luqman" wrote:

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