Genaral question about servers

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
AphexTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tacobell777Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AphexTAuthor Commented:
Ahhh so     SQL Server = SQL 2000 = Microsoft SQL

They are all same thing?
0
AphexTAuthor Commented:
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
Tacobell777Commented:
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
fz2hqsCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

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.