I am trying to determine an ideal approach for purchasing SQL Server 2008. I am not too sure about the license and pricing options. Below is what I need. Can someone help me determine what option is best and cost effective?
I will have one public anonymous web application/site (no authentication needed. site pulls data from SQL)
I will have one internal web application running (this app will authenticate with AD and pull it's data from SQL also)
I will have a few Cold Fusion apps running that will also pull data from SQL (these applications will use Forms Based Authentication (i.e. authenticate with usernames and passwords stored in SQL)
I will need to work with SSIS and SQL Profiler.
I am not sure if I will need to purchase Standard Edition with a per processor (or external connector) license can I get away with a different licensing model?