Coldfusion Authenticate to SQL Server

I am working on a Web service that will be passed a username and password. I am looking to see if i can use the username and password to authenticate against SQL server using my web service. is this possible?

Thanks