SQL server

Posted on 2003-03-25
Medium Priority
Last Modified: 2010-04-20

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?


Question by:meravkn
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 14

Expert Comment

ID: 8211241
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.

Expert Comment

ID: 8212284
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.

Accepted Solution

fz2hqs earned 1000 total points
ID: 8223959
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


Expert Comment

ID: 8569207
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.


Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question