Microsoft SQL Server 2005 Installation
Author: jason
Date: 2008-04-08 23:46:50
Category: Technical

Here is a quick run-through on installing SQL Server 2005. This install uses the Developer edition of SQL Server 2005.

To install the Reporting Services function of SQL 2005 the base server needs to have Internet Information Server installed. The Reporting Service will create a couple Virtual Directories in IIS. Also, not having IIS installed will cause the setup to gray out the option of selecting Reporting Services.

Preparations
Install the latest service pack and patches
Install the latest .NET Framework
Install and configure Internet Information Services
a) Go into Control Panel, Add/Remove Programs, Add/Remove Windows Components
b) Go into the Details of the Application Server
c) Go into the Details of the Internet Information Services (IIS)
d) Check World Wide Web Service
e) Check ASP.NET
f) Click OK and Next through the install screens
g) Have the Windows CD ready to copy the necessary files


Installation
Insert the Microsoft SQL 2005 CD/DVD into the server
Right-click the CD/DVD drive select AutoPlay
Select the correct operating system, most likely x86-based



In the Install section click, "Server components, tools, Books Online, and samples"



Accept the license agreement



Click Install to continue



Click Next, after the prerequisites have been installed



Click Next on the install welcome screen



Confirm the configuration check. If something has not passed, then review the message and fix the problem before continuing



Enter a name and/or company and the product key



Check all the components. I'm checking everything, because I want it all. All!! And well, what if I need it later? Also, selecting the "Workstation components" will add "Business Intelligence Development Studio" which is a stripped down Visual Studio 2005 with report modules. It can be used to build reports for the Reporting Services function.



Ensure "Default instance" is selected



Use the "Local system" account for the service account



Select "Mixed Mode"
Enter a password for the "sa" account



Click Next



Select "Install the default configuration" for Report Server Installation Options



Informational Only: clicking details on the prior screen displays this information concerning the Report Server configuration



Click Next on the Error and Usage Report Settings



Click Next to install SQL Server 2005



Wait while SQL installs



Click Next



Click Finish



Congrats



jason @ jasonthomasfrance.com - www.masterstationlog.com - copyright 2009