Solved

Genaral question about servers

Posted on 2003-11-11
5
317 Views
Last Modified: 2010-04-20
What is the difference between SQL Server and IIS? What can you do with one that you cannot do with the other?

SQL 2000 is a server, right? Which is the best between the 3 of them?

Are they free to download? Just a Y/N answer is fine, don’t need url’s

Thanks a million

Ohh 1 more. What is IIS Admin in respect to IIS?

Thanks again
0
Comment
Question by:AphexT
  • 2
  • 2
5 Comments
 
LVL 17

Accepted Solution

by:
Tacobell777 earned 100 total points
ID: 9729910
SQL Server is a database server, i.e. to store data in.
IIS is a webserver, i.e. to server webpages from.

> SQL 2000 is a server, right? Which is the best between the 3 of them?

3??

I don't see 3, I see SQL Server and IIS, unless you think SQL Server 2000 is something different than SQL Server? They are both the same, the 2000 part is the version of the software (well actually V8).

SQL Server for production is not free and costs a bundle! MySQL is Free....
IIS is free if you already have a Windows license, i.e. Windows 2000 or professional.

IIS Admin is the place where you can administrate IIS from, it is web based...

No worries...
0
 

Author Comment

by:AphexT
ID: 9736189
Ahhh so     SQL Server = SQL 2000 = Microsoft SQL

They are all same thing?
0
 

Author Comment

by:AphexT
ID: 9736278
One more....

So is SQL Server a DBMS just like MS access. What's the difference between a DBMS and a database server?   .... using IIS you can't display database queries on the web without, say, IIS and with Access you can't display database query results on the web without, say, IIS, so what is the difference between Access and SQL Server then?

Sorry about the dump ass Q!
0
 
LVL 17

Expert Comment

by:Tacobell777
ID: 9737946
There is no difference between a RDBMS, DBMS or Database Server, they are all the same just another fancy acronym for something, i.e. Relational Database Management System

Difference between access and MS SQL is that Access if more for desktop application (but will do for a small site) and MS SQL is more for the web and enterprise solutions.
0
 
LVL 9

Expert Comment

by:fz2hqs
ID: 9738389
Tacobell777 seems to have given you almost everything...

"What is IIS Admin in respect to IIS"
You either want to know what is the IIS HTML Management Interface, or what is the IIS MMC. Both are ways to manage IIS, only the HTML one is rubbish... uninstall it if you have it on there. The MMC (Microsoft Management Console) can have an IIS Snap-in which allows you to change server settings. In Control Panel > Administrative Tools you will find an internet services manager

Free to download?
IIS = Free (but you have to buy the operating system first) it will be on the installation cd (assuming w2k or w2k3)
SQL = big bucks
0

Featured Post

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

Join & Write a Comment

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now