Beginner ASP Data Connection Question

[=?Utf-8?B?TkMgQmVhY2ggQnVt?=]

I am new to ASP and working on my first project and I must setup a connection
to my sql server. I have been working in Coldfusion and new to ASP. I am
thinking the best way to setup the SQL Database connection is with a single
user logon ID and Password from the web server to the sql server. Then as a
SQL Server query check the Logon ID and Pasword on the user using the web
application. Does this sound right? If so, can you point me to
documentation on how to set this up? If not, then what should I do and can
you point me to documenation on how to set this up.

Thanks on helping!
--
NC Beach Bum