• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

SQL server


If I have a dedicated server that's hosting my site, and I would like to have the sql server inside the server (right now it's on a shared sql server), what kind of software/license do I need to buy?


1 Solution
I suppose you work with IIS & M$ SQL Server and you have two servers, one runnig IIS and an other with SQL Server.
It's generally a good practice to separate web servers and database servers, so you shouldn't change anything.
Anyway, if you want to do this you don't need to buy any software or any licence.
Licence for the operating system, ie: Windows 2000 Server, which include IIS and a licence for Microsoft SQL Server.

You can run IIS and SQL Server on the same machine as long as you dont require top performance or don't expect much hits/queries. It also depends on the hardware ofcourse.
MS Server licensing.... rarely is there consensus of opinion on this L I believe that you will need
1.     OS Licence.
2.     Internet Connector license for OS if IIS is publicly exposed, this means you do not have to get CAL’s for each user that accesses the site
3.     SQL Server Licence – this should be purchased per processor rather than going down the CAL route

In terms of software; as you point out just the OS & MSSQL. Both the standard server editions… you do not seem like you are going to go for clustering so the enterprise / advanced editions are pointless

I tend to agree with Stuart,

I operate many dedicated servers that run both Win2000 and MsSQL2000 for Internet sites. The licencing for MsSQL requires us to go with per processor licences as it starts to get difficut (rather impossible) to estimate the number of licences to buy for the Internet.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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