SQL Server 2008 Licensing

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?
obautistaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
k_murli_krishnaCommented:
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)

These 2 are not a problem.

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):

Connecting SQL Server 2008 to ColdFusion
http://blog.mxunit.org/2009/02/connecting-sql-server-2008-to.html
connect to sql server 2008 database via coldfusion administration
http://forums.crystaltech.com/index.php?topic=33640.0

I will need to work with SSIS and SQL Profiler: These will be available in all licensed server editions and versions.

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?

SQL Server 2008 licensing - do I need an external connector license?
http://serverfault.com/questions/31482/sql-server-2008-licensing-do-i-need-an-external-connector-license
I repeat once again:
SQL Server licensing, is it per CPU? So a 32 CPU would mean like 150K in licensing?
http://serverfault.com/questions/29018/sql-server-licensing-is-it-per-cpu-so-a-32-cpu-would-mean-like-150k-in-licensi/29143#29143
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.