By 'connect' do you mean useing a trusted connection, authenticated by the OS? Or do you mean authneticated by an application (their usernames and passwords are stored in a table in SQL server)? or authenticated by the SQL server persmissions/security?
There are different methods based on your response to the above questions ;)
Ricardo A. Parodi
eSolar, Inc.