[2005] Authenticate a SQL user

What is the best way for me to authenticate a SQL 2000 username and password? Should I attempt a connection with that username and password or is there a better technique.

Thanks,
Rob

Well you can also do windows authentication.