[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

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?
0
obautista
Asked:
obautista
  • 2
1 Solution
 
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

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now