Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL SERVER

Posted on 2011-02-19
9
Medium Priority
?
331 Views
Last Modified: 2012-08-13
What is the role of SQL Server in exchange? Why do we also need IIS Sever in exchange?
0
Comment
Question by:kunalclk
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 17

Expert Comment

by:OriNetworks
ID: 34935203
Sql server has no relation to exchange. IIS is a requirement of exchange to make outlook web access accessible by web browser, the smtp connector and other features deending on the exchange and OS version.
0
 
LVL 29

Accepted Solution

by:
mass2612 earned 500 total points
ID: 34935412
Hi,

Exchange uses the Extensible Storage Engine as its database. The ESE database has been optimized for the type of ad-hoc workload that Exchange generates and therefore its unlikely the SQL will ever be used as the database for Exchange mainly due to the vastly different indexing requirements between Exchange and most OLTP systems.
0
 
LVL 2

Author Comment

by:kunalclk
ID: 34935979
How the OWA, smtp connector be made accessible by IIS. I was told how will you take backup of sql database while taking exchange backup. I do not know how sql is related to exchange.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 2

Author Comment

by:kunalclk
ID: 34936072
Any Updates???
0
 
LVL 29

Expert Comment

by:mass2612
ID: 34936688
What versions are you running? What is prompting these questions? Exchange services such as OWA link into IIS as part of the architecture of Exchange.

SQL is not related to Exchange at all. I would not run SQL and Exchange on the same server in production.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 500 total points
ID: 34937141
SQL Server is not related to MS Exchange ...

the only thing that could be is that you have a SmallBusinessServer, in which both SQL Server and MS Exchange are installed ...

IIS is to enable OWA (Exchange over Web), but otherwise not required for exchange / outlook
0
 
LVL 2

Author Comment

by:kunalclk
ID: 34938035
Recently in an interview I was asked of why do we use SQL Database in an Organization, How and why shall we take backup of sql database and exchange? Next I will like to know of the procedure of making OWA and how IIS helps step by step...
0
 
LVL 17

Expert Comment

by:OriNetworks
ID: 34945833
For additional questions, experts-exchange recommends asking a separate question and closing answered questions by awarding points to the experts that have answered the original question. I would recommend posting in the SQL Server zone for the question about backup of sql database and Exchange server zone about any questions related to OWA.   If you are asking how to setup OWA, this is part of the install process when you install Exchange onto the server.
0
 
LVL 2

Author Closing Comment

by:kunalclk
ID: 34948030
Thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

916 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