your options are either a domain account or a sql server login. The web application should be able to handle both - it should have a configuration setting somewhere that allows you to set this up. It is fairly common to use a single sql server login for web applications althoug, if you can, use a domain account.