Configure Sql Essay

Submitted By Singlesunny1
Words: 3037
Pages: 13

INSTALLING MICROSOFT SQL SERVER AND CONFIGURING REPORTING SERVICES
TECHNICAL ARTICLE
November 2012

Copyright © 2012 NetWrix Corporation. All Rights Reserved.

Installing Microsoft SQL Server and Configuring Reporting Services

Legal Notice The information in this publication is furnished for information use only, and does not constitute a commitment from NetWrix Corporation of any features or functions discussed. NetWrix Corporation assumes no responsibility or liability for the accuracy of the information presented, which is subject to change without notice. NetWrix is a registered trademark of NetWrix Corporation. The NetWrix logo and all other NetWrix product or service names and slogans are registered trademarks or trademarks of NetWrix Corporation. Active Directory is a trademark of Microsoft Corporation. All other trademarks and registered trademarks are property of their respective owners. Disclaimers This document may contain information regarding the use and installation of non-NetWrix products. Please note that this information is provided as a courtesy to assist you. While NetWrix tries to ensure that this information accurately reflects the information provided by the supplier, please refer to the materials provided with any non-NetWrix product and contact the supplier for confirmation. NetWrix Corporation assumes no responsibility or liability for incorrect or incomplete information provided about non-NetWrix products.

© 2012 NetWrix Corporation.
All rights reserved.

Copyright © 2012 NetWrix Corporation. All Rights Reserved Suggestions or comments about this document? www.netwrix.com/feedback

Page 2 of 19

Installing Microsoft SQL Server and Configuring Reporting Services

Table of Contents
1. INTRODUCTION ................................................................................ 4 1.1. Overview .............................................................................. 4 1.2. How This Guide is Organized ....................................................... 4 2. INSTALLING MICROSOFT SQL SERVER 2005 EXPRESS AND CONFIGURING REPORTING SERVICES ...................................................................................... 5 2.1. System Requirements ............................................................... 5 2.1.1. Hardware Requirements .................................................... 5 2.1.2. Software Requirements ..................................................... 5 2.2. Configuring IIS ........................................................................ 6 2.2.1. Configuring IIS on Windows 7/Windows Vista ............................ 6 2.2.2. Configuring IIS on Windows 2008 ........................................... 6 2.3. Installing SQL Server 2005 Express ................................................ 9 2.4. Enabling Script Execution in IIS ................................................... 10 3. INSTALLING MICROSOFT SQL SERVER 2008 R2 EXPRESS AND CONFIGURING REPORTING SERVICES .................................................................................... 12 3.1. System Requirements .............................................................. 12 3.1.1. Hardware Requirements ................................................... 12 3.1.2. Software Requirements .................................................... 12 3.2. Installing SQL Server 2008 R2 Express............................................ 13 3.3. Verifying Reporting Services Installation ........................................ 14 4. INSTALLING MICROSOFT SQL SERVER 2012 EXPRESS AND CONFIGURING REPORTING SERVICES .................................................................................... 16 4.1. System Requirements .............................................................. 16 4.1.1. Hardware Requirements ................................................... 16 4.1.2. Software Requirements .................................................... 16 4.2. Installing SQL Server 2012…