Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


what is the relation between SQL and IIS

Posted on 2010-08-17
Medium Priority
Last Modified: 2012-05-10
what is the relation between SQL and IIS?
Question by:kunalclk
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

Accepted Solution

jmiller47 earned 750 total points
ID: 33458537
IIS is the Microsoft Web server. Its only purpose is to serve web pages to people who request them. SQL Server is the Microsoft database server. It allows users to create databases, tables, views, stored procedures, functions, etc. and write code that stores and retreives data. The only relationship between the two is that someone can write web code to be put on a web server that queries a SQL Server , runs stores procedures on a SQL Server, or inserts/deletes records on a SQL Server. Otherwise, they have no direct relationship.

Both are Server software packages that are installed on Windows. Both perform entirely different tasks. Together, they can both be utilized by a web application. The web application can be web pages served from an IIS web server and the same web pages can communicate to a SQL Server database to store and retrieve data.

Assisted Solution

by:Pramod Bugudai
Pramod Bugudai earned 750 total points
ID: 33462796

Expert Comment

ID: 33514125
yes above both comments are gud.

Author Closing Comment

ID: 33563105

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

610 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