obautista
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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