<div>
by &quot;reports on a SQL database&quot; , do you mean SQL Server Reporting Services reports? &nbsp;If not, can you explain a little more about these reports? &nbsp;Are they files stored in SQL? &nbsp;Queries that will return data from SQL? &nbsp;or ???
</div>


by "reports on a SQL database" , do you mean SQL Server Reporting Services reports?  If not, can you explain a little more about these reports?  Are they files stored in SQL?  Queries that will return data from SQL?  or ???

<div>
stored procedure to retrieve data from SQL data base.
</div>


stored procedure to retrieve data from SQL data base.

<div>
<div class="content wysiwyg-content">
Users will access a web site to access reports on a SQL data base.<br />
<br />
I'm looking for some direction on how to implement a web server and and SQL database. &nbsp;In terms of security and manageability what is the best practice? &nbsp;Should they exist in a Active Directory or as stand alone servers in a work group? &nbsp;Is it best to put the web servers in a DMZ zone or can they exist in the same zone?
</div>
</div>


Users will access a web site to access reports on a SQL data base.

I'm looking for some direction on how to implement a web server and and SQL database.  In terms of security and manageability what is the best practice?  Should they exist in a Active Directory or as stand alone servers in a work group?  Is it best to put the web servers in a DMZ zone or can they exist in the same zone?

How to Connect Windows IIS Servers wtih SQL Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.